The following metrics are available for each SQL Server instance of the Management Pack for Microsoft Azure in vRealize Operations .
For more information about each metric, see the Microsoft Azure documentation at https://docs.microsoft.com/en-us/azure/azure-monitor/platform/metrics-supported.
| Name | Type | Unit | Aggregation Type | Description |
|---|---|---|---|---|
| CPU Percentage | Metric | Percent | Average | The average percentage of CPU used in the SQL Server databases. |
| SQL Version | Property | String | Not applicable. | The version of the SQL Server. |
| Data IO Percentage | Metric | Percent | Average | The average percentage of data IO used in the SQL Server databases. |
| DTU Used | Metric | Count | Average | The average number of DTUs used in the DTU-based SQL Server databases. |
| In-Memory OLTP Storage Percent | Metric | Percent | Average | The average percentage of in-memory OLTP storage in the SQL Server databases. |
| Log IO Percentage | Metric | Percent | Average | The average percentage of log IO used in the SQL Server databases. |
| Sessions Percentage | Metric | Percent | Average | The average percentage of sessions in the SQL Server databases. |
| Workers Percentage | Metric | Percent | Average | The average percentage of workers in the SQL Server databases. |
