What is the replacement for SQL Insights for SQL Server in Azure VM?

Ammara Sheikh 40 Reputation points
2025-01-02T15:31:13.3333333+00:00

Hi,

I am just wondering about the below Note on the SQL Insights Preview feature. What is the replacement monitoring tool for SQL Server in Azure VM as SQL Insights has retired and database watcher does not support SQL in Azure VM?

https://zcusa.951200.xyz/en-us/azure/azure-sql/database/sql-insights-overview?view=azuresql

SQL Insights (preview) will be retired on 31 December 2024. We recommend that you transition to database watcher for Azure SQL (preview) or another database monitoring solution by that date.

Thanks

SQL Server on Azure Virtual Machines
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,293 questions
0 comments No comments
{count} votes

Accepted answer
  1. Oury Ba-MSFT 19,996 Reputation points Microsoft Employee
    2025-01-02T17:58:55.73+00:00

    Ammara Sheikh Thank you for posting your question on Microsoft Q&A forum.

    For customers asking about alternatives, we've been advising them to consider the following options:

     Adding support for SQL VM in database watcher remains on our roadmap, though we do not have a timeline to share at this time.

    Hope that help.

    Please don't forget to mark as accept answer if the reply was helpful.

    Regards,

    Oury


    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Divyesh Govaerdhanan 485 Reputation points
    2025-01-02T16:11:29.7166667+00:00

    Hello,

    Welcome to Microsoft Q&A,

    The alternate approach to Monitor SQL on Azure VM is to use Azure Monitor. By using Azure Monitor to monitor your SQL Server instances, you can gain insights into the performance and health of your databases and take proactive steps to address any issues that arise. Here is a link to YouTube where you can learn how to set up insights. https://www.youtube.com/watch?v=OwNS6wbPhyI

    Data that will be collected using Azure Monitor:

    https://zcusa.951200.xyz/en-us/azure/azure-sql/database/sql-insights-overview?view=azuresql#data-for-sql-server

    Please Upvote and Accept this as an Answer if it helps!

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.