Azure SQL Database metrics and alerts
Published 02 November 2023
This documentation contains a list of metrics and alerts that are available when monitoring Azure SQL Databases. If you can't find a specific metric or alert you would like to use when monitoring your Azure SQL Databases, send us feedback.
Metrics
The following lists the metrics SQL Monitor collects and exposes on the Analysis page:
Azure SQL Databases metrics
- DTU percent
- CPU percent
- Data I/O percent
- Log I/O percent
- Memory used percent
- User connections
- SQL Server: total memory
- SQL Server: target memory
- SQL Server: free memory
- SQL Server: plan cache memory
- Batch requests/sec
- Compilations/sec
- Compilations/batch
- Recompilations/sec
- Buffer page life expectancy
- Full scans/sec
- Page splits/sec
- Page splits/batch request
- Latch wait time
- Lock timeouts/sec
- Lock waits/sec
- Avg. lock wait time
- Transactions/sec
- Active transactions
- Log bytes flushed/sec
- Log flushes/sec
- Log flush waits/sec
- Data size
- Worker thread percent
- Session percent
Elastic Pool metrics
- DTU percent
- CPU percent
- Data I/O percent
- Log I/O percent
- Worker thread percent
- Session percent
Alerts
The following is a list of alerts available for Azure SQL Databases:
- SQL Database specific alerts
- Data I/O utilization
- Database Space Limit
- DTU utilization
- Log I/O utilization
- Processor (CPU) utilization
- Session limit
- Worker thread limit
- Elastic Pool specific alerts
- Data I/O utilization
- DTU utilization
- Log I/O utilization
- Low storage
- Processor (CPU) utilization
- Session limit
- Worker thread limit
- SQL Server specific alerts
- Blocking process
- Custom metric
- Custom metric collection error
- Database unavailable
Deadlock (extended event)
- Internal SQL Monitor error (SQL server)
- Instance unreachable
- Long-running query
- Monitoring stopped (Instance credentials)
- Page Life Expectancy
- Server waits