Other
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_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_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_MEM_MB
SQLServer Memory(MB) exceeds value rule
MSSQL_GLOB_TOTAL_CPU
Total CPU % exceeded 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_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
Parent topic:
Rules By Category