SQL Monitor 11

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
  • 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

Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?