Monitor IO of SQL Server Instance on Azure VM

MS Techie 2,681 Reputation points
2021-09-11T17:29:46.127+00:00

How to monitor total % of I/O for SQL Server instance on Azure VM ?

I see lot of I/O performance counters in the Log analytics workspace , under agent configuration like below.
Database ==> Instances()\Database Maintenance IO Re-Reads Average Bytes
Database ==> Instances()\Database Maintenance IO Re-Reads Average Latency
Database ==> Instances()\Database Maintenance IO Re-Reads/sec
SQLServer:Resource Pool Stats()\Avg Disk Read IO (ms)
SQLServer:Resource Pool Stats()\Disk Write IO Throttled/sec
SQLServer:Resource Pool Stats()\Disk Write IO/sec

Is there a way to get Consolidate IO of the Azure VM via Log Analytics Query and which performance counter to enable for it ?

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,829 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. SwathiDhanwada-MSFT 17,726 Reputation points
    2021-09-23T12:19:53.997+00:00

    @MS Techie You can monitor SQL server instances which are on Azure VM using SQL insights(preview) solution of Azure Monitor. To know how to enable it and what type of data is collected , I would suggest you to check this document. Kindly revert if you have any further questions.

    0 comments
  2. Tiago Fernandes 0 Reputation points Microsoft Employee
    2023-04-28T12:20:47.88+00:00

    @MS Techie You can use Azure Portal Virtual Machine Metrics to have an overall perspective.

    Azure Metrics Throttle storage example

    0 comments