Rules
MSSQL_AGDB_LATENCY
Check Availability Group (AG) database replica latency rule
MSSQL_AGDB_NOTJOINED
AG database replica is not joined rule
MSSQL_AGDB_RECEIVED_EVER
Have AG messages ever been received? rule
MSSQL_AGDB_RECEIVED_RECENT
Have AG messages been received within the last # seconds? rule
MSSQL_AGDB_SUSPENDED
AG database replica is suspended rule
MSSQL_AGDB_UNHEALTHY
AG database replica is not healthy rule
MSSQL_AGREPLICAS_DISCONNECTED
AG replica is disconnected rule
MSSQL_AG_OFFLINE_LISTENERS
Too many AG listeners are offline rule
MSSQL_BLOCKTREE_WAITER
Waiter has been blocked over time thresholds rule
MSSQL_BUFF_CACHEHIT_ALERT
Buffer Mgr CacheHit < value(Alert) rule
MSSQL_BUFF_CACHEHIT_WARN
Buffer Mgr CacheHit < value(Warn) rule
MSSQL_BUFF_FREEBUFFERS
Buffer Mgr Free Buffers < value rule
MSSQL_DBUSAGE_AUTOSHRINK_ON
Database has auto-shrink enabled, which is often problematic rule
MSSQL_DBUSAGE_DATABASE_OFFLINE
Database is in an offline, emergency, or other such critical state rule
MSSQL_DBUSAGE_DATABASE_RECOVERY
Database is in a restoring / recovery state rule
MSSQL_DBUSAGE_MULTIPLE_LOGFILES
Database has multiple log files, which can be less than optimal rule
MSSQL_DBUSAGE_OFFLINE_FILES
Database is online, but has offline files rule
MSSQL_DBUSAGE_SUSPECT_PAGES
Database contains suspect pages rule
MSSQL_FGUSAGE_DATA_CRITICAL
Filegroup usage > value (percentage full) and if small filegroup, free space < value (MB free) rule
MSSQL_FGUSAGE_DATA_INFO
Filegroup usage > value (percentage full) and if small volume, free space < value (MB free) rule
MSSQL_FGUSAGE_DATA_WARNING
Filegroup usage > value (percentage full) and if small volume, free space < value (MB free) rule
MSSQL_FGUSAGE_LOG_CRITICAL
Database log usage > value (percentage full) and if small filegroup, free space < value (MB free) rule
MSSQL_FGUSAGE_LOG_INFO
Database log usage > value (percentage full) and if small filegroup, free space < value (MB free) rule
MSSQL_FGUSAGE_LOG_WARNING
Database log usage > value (percentage full) and if small filegroup, free space < value (MB free) rule
MSSQL_FILEUSAGE_SPACEBOUNDALLOC
Next file OS allocation exceeds OS free space rule
MSSQL_GLOB_BATCH_REQS
Batch requests/sec exceeds value rule
MSSQL_GLOB_BLOCKED
Blocked Process count exceeds value rule
MSSQL_GLOB_LOCKS
Lock count exceeds value rule
MSSQL_GLOB_PROCESSES
Process count exceeds value rule
MSSQL_GLOB_RUNNING_JOBS
Running job count exceeds value rule
MSSQL_GLOB_SQLSVR_CPU
SQLServer CPU % exceeds value rule
MSSQL_GLOB_SQLSVR_CPU_OVERALL
SQLServer CPU % (overall) exceeds value rule
MSSQL_GLOB_SQLSVR_DISKIO
SQLSvr Disk IO/sec exceeds value rule
MSSQL_GLOB_SQLSVR_MEM_MB
SQLServer Memory(MB) exceeds value rule
MSSQL_GLOB_TOTAL_CPU
Total CPU % exceeded value rule
MSSQL_GLOB_TOTAL_DISKIO
Total Disk IO/sec exceeds value rule
MSSQL_LOGDEVIO_IOSPERSEC
Log Dev IO rate > value rule
MSSQL_LOGDEVIO_USEDPERCENT
Log Dev % space usage > value rule
MSSQL_LOGFILE_ERROR
Error SQL Server log entry found rule
MSSQL_MEMORY_AVAILBYTES
System Memory Avail < value rule
MSSQL_MEMORY_PAGESPERSEC
System Memory Pages/sec > value rule
MSSQL_PROCESS_BLOCKED_TIME
Seconds Blocked exceeds value rule
MSSQL_PROCESS_CPU_PERCENT
Process CPU % exceeds value rule
MSSQL_PROCESS_CPUSECS
Process CPU secs exceeds value rule
MSSQL_PROCESS_DECEASED_SPID
Record Deceased SPIDs rule
MSSQL_PROCESS_NEW_SPID
Record New SPIDs rule
MSSQL_PROCESS_PHYSIO_RATE
Physical IO rate exceeds value rule
MSSQL_PROCESS_STATUS
Process status like value rule
MSSQL_STMT_LONGRUNNING
Statement running for time > value (seconds) rule
MSSQL_SYSTEM_PROCQUEUELEN
Processor Queue Len exceeds value rule
MSSQL_SYSTEM_PROCTIME_ALERT
%Total Proc Time exceeds value (Alert) rule
MSSQL_SYSTEM_PROCTIME_WARN
%Total Proc Time exceeds value (warn) rule