The following metrics are available for each SQL Server instance of the Management Pack for Microsoft Azure in VMware Aria 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. |
