Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

About each alarm

Legend: Keys - Configure Keyed Alarms. Ignore - Do not alarm for certain values. Diag - Collect additional diagnostic information.

Alarm Name Type Keys Ignore Diag
Availability Group - Failed Over Alarm Availability Groups      
Availability Group - Failover Availability Alarm Availability Groups      
Availability Group - Quorum Failure Imminent Alarm Availability Groups      
Availability Group - Synchronization Health Alarm Availability Groups      
Backup - Days Since Last Full Backup (Backup Alarms) SQL Server Y Y  
Backup - Hours Since Last Differential Backup (Backup Alarms) SQL Server Y Y  
Backup - Minutes Since Last Log Backup (Backup Alarms) SQL Server Y Y  
Clusters - Failed Over Alarm SQL Server      
Clusters - File Share Witness inaccessible alarm SQL Server      
Clusters - Node Unavailable Alarm SQL Server      
Clusters - Non-Preferred Node Alarm SQL Server      
Command - Long Running Command Alarm Analysis Services Y Y  
Compiles - Percentage Recompilations Alarm SQL Server     Y
CPU - Average CPU Usage Alarm Windows     Y
CPU - Individual CPU Usage Alarm Windows Y Y Y
CPU - Processor Queue Length Alarm Windows      
Cubes - Days Since Last Processed Alarm Analysis Services Y Y  
Cubes - Unprocessed Alarm Analysis Services Y Y  
Databases - Data File Group Space Used Alarm SQL Server Y Y  
Databases - Dynamic Data File Group Growths Remaining Alarm SQL Server Y Y  
Databases - Dynamic Log File Growths Remaining Alarm SQL Server Y Y  
Databases - Log File Space Used Alarm SQL Server Y Y  
Databases - Log Flush Wait Time Alarm SQL Server Y Y  
Databases - SQL I/O Errors Alarm SQL Server      
Databases - Unavailable Alarm SQL Server Y Y  
Diagnostic Server - Alarm Action Failure (Monitored Server Alarms) Diagnostic Server Y Y  
Diagnostic Server - Alarm Evaluation Failure (Monitored Server Alarms) Diagnostic Server Y Y  
Diagnostic Server - Auto Update Failure Alarm Diagnostic Server      
Diagnostic Server - Auto Update Success Alarm Diagnostic Server      
Diagnostic Server - Collection Execution Failure (Monitored Server Alarms) Diagnostic Server Y Y  
Diagnostic Server - Email Service Diagnostic Server Y Y  
Diagnostic Server - Federation Communications Failure Alarm Diagnostic Server      
Diagnostic Server - License Service Diagnostic Server      
Diagnostic Server - Microsoft .NET version Diagnostic Server      
Diagnostic Server - PagerDuty Service Diagnostic Server Y Y  
Diagnostic Server - Push notification to mobile device Diagnostic Server      
Diagnostic Server - SNMP Service Alarm Diagnostic Server Y Y  
Diagnostic Server - Spotlight Cloud data transfer alarm Diagnostic Server      
Diagnostic Server - Spotlight Playback Diagnostic Server Y Y  
Diagnostic Server - Spotlight Statistics Repository Diagnostic Server Y Y  
Disks - Free Space (Disks - Percentage Used Alarm / Free Space Alarm) Windows      
Disks - Percentage Used (Disks - Percentage Used Alarm / Free Space Alarm) Windows Y Y  
Disks - Queue Length alarm Windows     Y
Disks - Transfer Time alarm Windows      
Error Log - Error Count Alarm SQL Server      
File - Exceeded Set Size Alarm Windows Y Y  
Hyper-V - Virtual Overhead Windows      
Hyper-V CPU wait time per dispatch alarm Windows      
Hyper-V Virtual Machine Heartbeat Alarm Windows      
I/O Stall Time Alarm SQL Server     Y
Index Fragmentation Alarm SQL Server      
Index Fragmentation Status Alarm SQL Server      
Latch - Total Wait Time Rate Alarm SQL Server      
LiteSpeed Backup Alarms SQL Server Y Y  
Locks - Blocked Processes Alarm SQL Server Y Y Y
Locks - Deadlocks Alarm SQL Server     Y
Log Shipping - Primary Backup Job Alarm SQL Server Y Y  
Log Shipping - Secondary Job Alarm SQL Server Y Y  
Log Shipping - Secondary Latency Alarm SQL Server Y Y  
Memory - Free System Page Table Entries Alarm Windows     Y
Memory - Page Life Expectancy Alarm SQL Server     Y
Memory - Percentage Free Virtual Memory Alarm Windows     Y
Memory - Physical Memory Available Alarm Windows     Y
Mirroring - State Alarm SQL Server Y Y  
Mirroring - Unrestored Log Alarm SQL Server Y Y  
Mirroring - Unsent Log Alarm SQL Server Y Y  
Mirroring - Failed Over Alarm SQL Server      
Missing SQL Performance Counters Alarm SQL Server      

Monitored Server Alarms

Analysis Services

Availability Groups

Hyper-V

SQL Server Replication

SQL Azure

SQL Server

VMware Virtualization

Windows

     
Network - Percentage Bandwidth Alarm Windows Y Y  
Network - SQL Server Packets Error Rate Alarm SQL Server      
Paging - Disk Activity Alarm Windows Y Y  
Paging - File Collision Alarm Windows Y Y  
Poor Performance Health Alarm SQL Server      
Replication - Distribution Agent Failure (Replication - Agent Failure Alarms) SQL Server Replication      
Replication - Distribution Latency (Replication - Latency Alarms) SQL Server Replication      
Replication - Estimated Time To Apply Alarm SQL Server Replication      
Replication - Log Reader Agent Failure (Replication - Agent Failure Alarms) SQL Server Replication      
Replication - Log Reader Latency (Replication - Latency Alarms) SQL Server Replication      
Replication - Merge Agent Failure (Replication - Agent Failure Alarms) SQL Server Replication      
Replication - Miscellaneous Agent Failure (Replication - Agent Failure Alarms) SQL Server Replication      
Replication - Publication Expiration Alarm SQL Server Replication      
Replication - Publication Failure Alarm SQL Server Replication      
Replication - Publisher Failure Alarm SQL Server Replication      
Replication - Queue Reader Agent Failure (Replication - Agent Failure Alarms) SQL Server Replication      
Replication - Snapshot Agent Failure (Replication - Agent Failure Alarms) SQL Server Replication      
Replication - Subscription Failure Alarm SQL Server Replication      
Replication - Undistributed Commands Alarm SQL Server Replication      
Services - DTC Service Status Alarm (Services - Service Not Running Alarms) SQL Server      
Services - Full Text Search Service Alarm (Services - Service Not Running Alarms) SQL Server      
Services - Integration Service Status (Services - Service Not Running Alarms) SQL Server      
Services - Reporting Service Status (Services - Service Not Running Alarms) SQL Server      
Services - Service Not Running Alarm Windows Y Y  
Services - SQL Mail Status Alarm / SQL Agent Mail Status Alarm SQL Server      
SQL - Long Running SQL alarm SQL Server Y Y Y
SQL Agent - Alerts Alarm SQL Server     Y
SQL Agent - Jobs Failed Alarm SQL Server Y Y  
SQL Agent - Long Running Jobs Alarms SQL Server Y Y  
SQL Agent - Status Alarm (Services - Service Not Running Alarms) SQL Server      
SQL Analysis - Aggregation Information Alarm SQL Server      
SQL Custom Counters Alarm SQL Server Y Y  
SQL Virtual Log Files Count alarm SQL Server      
Tempdb Auto Growth SQL Server      
Tempdb Contention SQL Server      
Tempdb File Location SQL Server      
Tempdb File Size SQL Server      
Tempdb Growth Settings SQL Server      
Tempdb Number of Files SQL Server      
Tempdb Version Store Generation Rate SQL Server      
Tempdb Version Store Size SQL Server      
User - Connection Count Alarm SQL Server      
User - Logins Per Second Alarm SQL Server      
User - Response Time Alarm SQL Server      
VMware - Memory Reposessed Alarm Windows      
VMware - Virtual Machine Heartbeat Alarm Windows      
VMware - Overhead Alarm Windows      
Windows Custom Counters Alarm Windows Y Y  
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating