VM (iaas) - SQL Server Monitoring in Azure Dashboard

Question

I want to show SQL server performance counters such as MAXDOP, top 50 queries and wait statistics, etc on the Azure dashboard.
SQL Server is installed in azure VM as IAAS. I already enabled sqlserveriaas extension on VM.Any idea?

Answer 1

Hello @Jaya Prakash - Thanks for reaching out.

You can use Azure Monitoring for that and also create alerts and use them based on performance counters (CPU / memory, etc)

Azure Monitor

Receive alert notifications

You can use it directly through the Azure Portal, or connect using c# for example.

Also there is a new product Azure SQL Analytics that is still in preview can also be used for cloud monitoring.

Take a look at this doc for more info : Azure SQL Monitoring

Hope this helps.

If the above response helped, Please feel free to "Accept as Answer" so it can be beneficial to the community.