SQL Diagnostic Manager offers numerous alerts to successfully monitor and warn you about your SQL Server instances and availability groups. Proper configuration is key to making sure you receive alerts only on those metrics that actually fall outside the typical performance of your environment. SQL Diagnostic Manager includes the following metric alerts for your use:
- Availability Group Estimated Data Loss (Seconds)
- Availability Group Estimated Recovery time (Seconds)
- Availability Group Log Send Queue Size (KB)
- Availability Group Preferred Replica
- Availability Group Redo Queue Size (KB)
- Availability Group Redo Rate (KB/sec)
- Availability Group Role Change
- Availability Group Synchronization Health
- Availability Group Synchronization Performance (Seconds)
- Average Disk Milliseconds Per Read
- Average Disk Milliseconds Per Transfer
- Average Disk Milliseconds Per Write
- Blocked Sessions
- Blocked Sessions Wait Time (Seconds)
- Client Computers
- CLR Enabled
- Cluster Active Node
- Cluster Failover
- Data File Autogrow
- Database Full (Percent)
- Database Full (Size)
- Database Read/Write Error Occurred
- Database Status
- Days since last backup
- Deadlock
- Disk Reads Per Second
- Disk Transfers Per Second
- Disk Writes Per Second
- Distribution Latency (Seconds)
- DTC Status
- Filegroup Space Full (Percent)
- Filegroup Space Full (Size)
- Full-Text Search Status
- Host CPU Usage (Percent)
- Host Memory Swap Detected
- Host Memory Usage (Percent)
- Host Power State
- Index Row Hits (Percent)
- Last Full-Text Catalog Update (Hours)
- Latent replication transaction (Count)
- Log File Autogrow
- Log Full (Percent)
- Log Full (Size)
- Longest Running Version Store Transaction (Minutes)
- Mirror Commit Overhead (Milliseconds)
- Mirrored Server Role Change
- Mirroring Oldest Unsent Transactions
- Mirroring Preferred Configuration
- Mirroring Status
- Mirroring Unrestored Log (KB)
- Mirroring Unsent Log (KB)
- Mirroring Witness Connection
- Oldest Open Transaction (Minutes)
- OLE Automation Disabled
- OS Average Disk Queue Length (Count)
- OS Average Disk Queue Length Per Disk (Count)
- OS Disk Free Space (Size)
- OS Disk Full (Percent)
- OS Disk Time (Percent)
- OS Disk Time Per Disk (Percent)
- OS Memory Usage (Percent)
- OS Metrics Collection Status
- OS Paging (Per Second)
- OS Privileged Time (Percent)
- OS Processor Queue Length (Count)
- OS Processor Time (Percent)
- OS User Time (Percent)
- Page Life Expectancy
- Procedure Cache Hit Ratio
- Query Monitor Events (Counts)
- Session CPU Time (Seconds)
- Session Tempdb Space Usage (MB)
- SQL Server Active Directory Helper Service Status
- SQL Server Agent Job Completion
- SQL Server Agent Job Failure
- SQL Server Agent Log
- SQL Server Agent Long Running Job (Minutes)
- SQL Server Agent Long Running Job (Percent)
- SQL Server Agent Status
- SQL Server Agent XPs Disabled
- SQL Server Browser Service Status
- SQL Server CPU Usage (Percent)
- SQL Server Data Used (Percent)
- SQL Server Error Log
- SQL Server Log Used (Percent)
- SQL Server Memory Usage (Percent)
- SQL Server Response Time (Milliseconds)
- SQL Server Status
- SQLdm Repository Grooming Timed Out
- Table Fragmentation (Percent)
- Tempdb Contention (ms)
- Unsubscribed Transactions (Count)
- Unsubscribed Transactions (Seconds)
- User Connections (Percent)
- Version Store Generation Ratio
- Version Store Size (MB)
- VM CPU Ready Wait Time (ms)
- VM CPU Usage (Percent)
- VM Host Server Change
- VM Memory Swap Delay Detected
- VM Memory Usage (Percent)
- VM Power State
- VM Reclaimed/Ballooned Memory (KB)
- VM Resource Configuration Change
- VM Resource Limits Detected
- WMI Service Unavailable