This documentation contains a list of metrics and alerts that are available when monitoring SQL Server on Linux instances. If you can't find a specific metric or alert you would like to use when monitoring your SQL Server on Linux instances, send us feedback.

Metrics

The following lists the metrics SQL Monitor collects and exposes on the Analysis page:

Host Linux machine metrics

• Machine: processor time
• Avg. CPU queue length
• Machine: memory used
• Memory pages/sec
• Network utilization
• Disk used
• Disk free
• Disk avg. read time
• Disk avg. write time
• Disk read bytes/sec
• Disk write bytes/sec
• Disk transfers/sec
• Avg. disk queue length

SQL Server on Linux metrics

• User connections
• SQL Server: processor time
• SQL Server: total memory
• SQL Server: target memory
• SQL Server: free memory
• SQL Server dynamic SQL cache memory
• SQL Server: connection memory
• SQL Server: lock memory
• SQL Server: optimizer memory
• SQL Server: buffer cache memory
• SQL Server: granted workspace memory
• SQL Server: log pool memory
• SQL Server: reserved server memory
• SQL Server: maximum workspace memory
• SQL Server: stolen server memory
• Memory grants pending
• SQL Server: plan cache memory
• Batch requests/sec
• Compilations/sec
• Compilations/batch
• Recompilations/sec
• Buffer page life expectancy
• Free list stalls/sec
• Page reads/sec
• Full scans/sec
• Page splits/sec
• Page splits/batch request
• 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
• Tempdb files: Free Bytes
• Tempdb files: Internal object bytes
• Tempdb files: Internal 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
• Tempdb version store: Longest running transaction time

SQL Server on Linux database metrics

• Transactions/sec
• Active transactions
• Total file size
• Total data file size
• Total data file used
• File size
• File used
• Total log size
• Total log space used
• Log space used
• Log bytes flushed/sec
• Log flushes/sec
• Log flush waits/sec
• Stalls per read
• Stalls per write
• Read bytes/sec
• Write bytes/sec

Alerts

The following is a list of alerts available for SQL Server on Linux:

• SQL Server specific alerts
  • Backup overdue
  • Blocking process
  • Configuration change
  • Custom metric
  • Custom metric collection error
  • Database file usage
  • Database unavailable

  • Deadlock (extended event)

  • Differential backup overdue
  • Fragmented indexes
  • Integrity check overdue
  • Internal SQL Monitor error (SQL server)
  • Job cancelled
  • Job duration unusual
  • Job failing
  • Log backup overdue
  • Long-running query
  • Monitoring error (SQL Server data collection)
  • Monitoring stopped (SQL server credentials)
  • Page Life Expectancy
  • Page verification
  • Server waits
  • SQL Server error log entry
  • SQL Server log entry
  • SQL Server instance unreachable
• Host machine alerts
  • Disk average read time
  • Disk average write time
  • Disk space
  • Internal SQL Monitor error (host)
  • Machine unreachable
  • Monitoring error (host machine data collection)
  • Monitoring stopped (host machine credentials)
  • Physical memory
  • Processor under-utilization
  • Processor utilization