@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.
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 ?
2 answers
Sort by: Most helpful
-
-
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.