The following metrics are available for each SQL Database 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 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. |
