The following metrics are available for each SQL Database 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 percentage of CPU in use. |
| Data IO Percentage | Metric | Percent | Average | The percentage of data IO in use. |
| Log IO Percentage | Metric | Percent | Average | The percentage of log IO in use. Not applicable to data warehouses. |
| DTU Percentage | Metric | Percent | Average | The percentage of DTU in use. Applies to DTU-based databases. |
| Data Space Used | Metric | Bytes | Maximum | The total size of the database. Not applicable to data warehouses. |
| Successful Connections | Metric | Count | Total | The number of successful connections to the database. |
| Failed Connections | Metric | Count | Total | The number of failed connections to the database. |
| Blocked by Firewall | Metric | Count | Total | The number of connections to the database blocked by firewall. |
| Deadlocks | Metric | Count | Total | The number of deadlocks. Not applicable to data warehouses. |
| Data Space Used Percent | Metric | Percent | Maximum | The percentage of database size. Not applicable to data warehouses or hyper-scale databases. |
| In-Memory OLTP Storage Percent | Metric | Percent | Average | The percentage of in-memory OLTP storage. Not applicable to data warehouses. |
| Workers Percentage | Metric | Percent | Average | The percentage of workers. Not applicable to data warehouses. |
| Sessions Percentage | Metric | Percent | Average | The percentage of sessions. Not applicable to data warehouses. |
| DTU Limit | Metric | Count | Average | The maximum number of DTUs. Applies to DTU-based databases. |
| DTU Used | Metric | Count | Average | The number of DTUs used. Applies to DTU-based databases. |
| CPU Limit | Metric | Count | Average | The maximum number of CPUs. Applies to vCore-based databases. |
| CPU Used | Metric | Count | Average | The number of CPUs used. Applies to vCore-based databases. |
| DWU Limit | Metric | Count | Maximum | The maximum number of DWUs. Applies only to data warehouses. |
| DWU Percentage | Metric | Percent | Maximum | The percentage of DWUs used. Applies only to data warehouses. |
| DWU Used | Metric | Count | Maximum | The number of DWUs used. Applies only to data warehouses. |
| DW Node Level CPU Percentage | Metric | Percent | Average | The DW node level CPU percentage. |
| DW Node Level Data IO Percentage | Metric | Percent | Average | The DW node level Data IO percentage. |
| Cache Hit Percentage | Metric | Percent | Maximum | The percentage of cache hits. Applies only to data warehouses. |
| Cache Used Percentage | Metric | Percent | Maximum | The percentage of cache used. Applies only to data warehouses. |
| Local tempdb Percentage | Metric | Percent | Average | The local tempdb percentage. Applies only to data warehouses. |
| App CPU Billed | Metric | Count | Total | The number of app CPUs billed. Applies to server-less databases. |
| App CPU Percentage | Metric | Percent | Average | The app CPU percentage. Applies to server-less databases. |
| App Memory Used Percentage | Metric | Percent | Average | The percentage of app memory used. Applies to server-less databases. |
| Data Space Allocated | Metric | Bytes | Average | The data space allocated. Not applicable to data warehouses. |
