question

MSTechie-7364 avatar image
0 Votes"
MSTechie-7364 asked SwathiDhanwada-MSFT answered

Monitor IO of SQL Server Instance on Azure VM

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-monitorazure-virtual-machines-monitoring
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SwathiDhanwada-MSFT avatar image
0 Votes"
SwathiDhanwada-MSFT answered

@MSTechie-7364 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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.