The following metrics are available for each SQL Database instance of the Management Pack for Microsoft Azure in vRealize Operations Manager .

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.