VM (iaas) - SQL Server Monitoring in Azure Dashboard

Jaya Prakash 1 Reputation point

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?

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
1,942 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Monalla-MSFT 6,656 Reputation points Microsoft Employee

    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.