Azure SQL Managed Instance metric and alerts
Published 10 February 2021
This documentation contains a list of metrics and alerts that are available when monitoring Azure SQL Managed Instances. If you can't find a specific metric or alert you would like to use when monitoring your Azure SQL Managed Instances, send us feedback.
Metrics
The following lists the metrics SQL Monitor collects and exposes on the Analysis page:
Azure SQL Managed Instance metrics
- SQL Server: processor time
- Latch wait time
- Lock timeouts/sec
- Lock waits/sec
- Avg. lock wait time
- Tempdb: Free bytes
- Tempdb: Internal object bytes
- Tempdb: User object bytes
- Tempdb: Mixed extent bytes
- Tempdb: Version store bytes
Azure SQL Managed Instance machine metrics
- Disk read bytes/sec
- Disk write bytes/sec
- Disk transfers/sec
Alerts
The following is a list of alerts available for Azure SQL Managed Instances:
- Blocking process
- Configuration change
- Custom metric
- Custom metric collection error
- Database file usage
- Database unavailable
Deadlock (extended event)
- Disk space
- Fragmented indexes
- Internal SQL Monitor error
- Job cancelled
- Job duration unusual
- Job failing
- Long-running query
- Monitoring error (SQL Server data collection)
- Monitoring stopped (SQL Server credentials)
- Processor under-utilization
- Processor utilization
- Server waits
- SQL Server error log entry
- SQL Server log entry
- SQL Server instance unreachable
- Configuration change