SQL Monitor 12

Azure SQL Managed Instance metric and alerts

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
  • Tempdb: Free bytes
  • Tempdb: Internal object bytes
  • Tempdb: User object bytes
  • Tempdb: Mixed extent bytes
  • Tempdb: Version store bytes
  • Lock waits/sec (removed in v12.0.10+)
  • Avg. lock wait time (removed in v12.0.10+)

Azure SQL Managed Instance metrics  (v12.0.10+)

  • User connections
  • SQL Server: total memory
  • SQL Server: target memory
  • SQL Server: free memory
  • SQL Server: plan cache memory
  • SQL Server: connection memory
  • SQL Server: lock memory
  • SQL Server: optimizer memory
  • SQL Server: buffer cache memory
  • SQL Server: log pool memory
  • SQL Server: maximum workspace memory
  • SQL Server: stolen server memory
  • Batch requests/sec
  • Compilations/sec
  • Compilations/batch
  • Recompilations/sec
  • Buffer page life expectancy
  • Page reads/sec
  • Full scans/sec
  • Page splits/sec
  • Page splits/batch request
  • Latch wait time
  • Tempdb files: Free bytes
  • Tempdb files: Internal object bytes
  • Tempdb files: User object bytes
  • Tempdb files: Mixed extent bytes
  • Tempdb files: Version store bytes
  • Tempdb version store: Generation rate bytes/sec
  • Tempdb version store: Cleanup rate bytes/sec

Azure SQL Managed Instance machine metrics

  • Disk read bytes/sec
  • Disk write bytes/sec
  • Disk transfers/sec

Azure SQL Managed Instance database metrics  (v12.0.10+)

  • Transactions/sec
  • Total file size
  • Total data file size
  • Total data file used
  • File size
  • File used
  • Total log file size
  • Total log space used
  • Log space used %
  • Log bytes flushed/sec
  • Log flushes/sec
  • Log flush waits/sec
  • Read stalls/sec
  • Write stalls/sec
  • Read bytes/sec
  • Write bytes/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
  • Version store usage

Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?