Storage
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_SQLSVR_DISKIO
SQLSvr Disk IO/sec exceeds 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
Parent topic:
Rules By Category