Azure SQL Database metrics and alerts

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 Redgate 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 Redgate Monitor error (SQL server)
    • Instance unreachable
    • Long-running query
    • Monitoring stopped (Instance credentials)
    • Page Life Expectancy
    • Server waits

Didn't find what you were looking for?