Documentation forDatabase Performance Analyzer

Azure SQL database metrics collected by DPA

The following sections list the metrics that DPA collects for Azure SQL database instances.

  • Learn how to view these metrics and change the thresholds.
  • For detailed information about resolving issues, click the next to the metric on the Resources tab. The Information link is not available for all metrics.
  • If the database instance runs on a virtual machine (VM), metrics collected for the VM are described in VM metrics collected by DPA

Connections

Metric Description
Connected Machines The number of distinct client machines connected to this database (even if the connection is idle).
Connected Users The number of distinct users (that is, login names) connected to this database (even if the connection is idle).
Sessions The number of sessions connected to this database (even if the connection is idle).

CPU

Metric Description
CPU Utilization

The percentage of CPU being used based on the DTU limit.

If CPU is near the upper limit, use DPA to determine which queries are contributing to high CPU usage, and determine if the queries can be tuned.

Disk

Metric Description
Data I/O Utilization The percentage of data I/O utilization based on the DTU limit.
Database Size The size of the database in GB (rounded up to the nearest GB).
Database Storage Consumption The percent of the storage available to the database that is currently used.
Log Write Utilization The percentage of log write Utilization based on the DTU limit.

DTU

Metric Description
DTU Consumption

The total number of DTUs (Database Transaction Units) being used.

A DTU represents a combination of CPU, memory, data I/O and transaction log I/O. Microsoft places limits on these resources based on what service tier a database is in. When a database exceeds its limit for any resource, Microsoft restricts throughput, which slows performance.

DTU Limit The DTU limit for this database instance.
DTU Utilization The percentage of available DTUs being used. Use this value to determine the appropriate service tier for your needs.

Memory

Metric Description
Memory Usage Utilization

The percentage of memory being used.

It is not unusual for this metric to be high. Data being used by applications is stored in memory to improve performance.

XTP Storage Utilization The percentage of XTP storage utilization based on the DTU limit. This resource is available only for databases running on the Premium service tier. Zero percent is returned for the Basic and Standard service tiers.

Network

Metric Description
Round-trip Time The round-trip time when running "select 1" against this database (includes network time but not connect time). If this is high, contact your network administrator to understand network latency.

Sessions

Metric Description
Active Sessions The number of sessions in this database actively performing work or waiting for a resource (excludes idle sessions).
Blocked Sessions The number of sessions in this database that are blocked because another session is using a needed resource.
Max Session Utilization The percentage of Max Session Utilization based on the database limit.
Max Worker Utilization The percentage of Max Worker Utilization based on the database limit.

Waits

Metric Description
Total Instance Wait Time Total wait time for the database instance.