VM (iaas) - SQL Server Monitoring in Azure Dashboard

Jaya Prakash 1 Reputation point
2021-07-08T09:34:18.047+00:00

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.
2,797 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalla-MSFT 11,551 Reputation points
    2021-08-12T15:18:45.24+00:00

    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.

    0 comments