| Always On Database Not Healthy | Always On | AO Availability group database not healthy |
|
Always On Database not ready for automatic failover |
Always On |
Always On Database not ready for automatic failover |
| Always On Error/Failover events | Always On | Always on error event occurred (possible failover) |
|
Always On Replication Time Lag Secondary Commit Behind |
Always on |
Always On Replication Time Lag Secondary Commit Lag Over @PARAM1 sec |
|
Always On Replication Time Lag Log sent |
Backup G Restore |
Always On Replication Time Lag Log sent from Primary to Secondary |
|
Database Bacfiup Operation Occured |
Backup G Restore |
Backup operation occurred |
|
Database Bacfiup Too Old |
Backup G Restore |
No @PARAM1 backup for over @PARAM2 @ PARAM3 |
|
Database No Bacfiup Exists |
Backup G Restore |
Database has no @PARAM1 backups |
|
Database Old Restore |
Backup G Restore |
Last restore older than @PARAM1 day |
|
Database Restore Operation Occured |
Backup G Restore |
Restore operation occurred on database |
|
Database Blocfiing |
Database Diagnostics |
Process is BLOCKING for over @PARAM1 sec onds |
|
Database Fragmented Index |
Database Diagnostics |
Alert if found fragmented index above @ PARAM1% (min index size: @PARAM2 pages) |
|
Database Has Connections |
Database Diagnostics |
Database has active connections |
|
Database Integrity Checfi Over due |
Database Diagnostics |
Last database integrity check check was |
|
Database Object Locfi |
Database Diagnostics | @PARAM1 object is LOCKED for over @PARAM2 seconds |
|
Database Object Type Locfi |
Database Diagnostics | @PARAM1 object LOCK occurs for over @ PARAM2 seconds |
| Database Page Verification Set To None | Database Diagnostics | Alert If Database Page Verification Set To None |
|
Database Process Locfi |
Database Diagnostics | Process is LOCKING for over @PARAM1 seconds |
|
Server Deadlocfi Monitor |
Database Diagnostics | Deadlock event occurred |
|
Database Data File Size Usage |
Database Files | Data file size usage is above @PARAM1% |
|
Database Data+Log Same Drive |
Database Files | Database DATA files and LOG files are on the same logical drive |
|
Database Log File Size Usage |
Database Files | Log file size usage is above @PARAM1% |
|
Database Log Size |
Database Files | Database LOG size is over @PARAM1% of the to tal database size (min log size: @PARAM2 MB) |
|
Database Total Data Size |
Database Files | Database DATA size is over @PARAM1 MB |
|
Database Total Log Size |
Database Files | Database LOG size is over @PARAM1 MB |
|
Database Total Size |
Database Files | Database TOTAL size is over @PARAM1MB |
|
Server Database Created |
Database Monitoring | Database was created/attached |
|
Server Database Deleted |
Database Monitoring | Database was deleted/detached |
|
Database Recovery |
Database Properties | Database RECOVERY is not @PARAM1 |
|
Database Status |
Database Properties | Database STATUS is not @PARAM1 |
|
Database Updateability |
Database Properties | Database UPDATEABILITY is not @PARAM1 |
|
Database User Access |
Database Properties | Database USER ACCESS is not @PARAM1 |
|
Dynamic_Wmi |
Dynamic | Dynamic Alert @PARAM1 @PARAM2 for @ PARAM3 |
|
AdHoc Distributed Queries |
Health Check | Ensure ‘Ad Hoc Distributed Queries’ Server Con figuration Option is set to ‘0’ |
|
Cross DB Ownership Chaining |
Health Check | Ensure ‘Cross db ownership chaining’ Server Configuration Option is set to ‘0’ |
|
Everyone Has Remote Access |
Health Check | The list of groups/users that have access to this computer from the network contains the group ‘Everyone’ |
|
OS Administrator Default Re moval |
Health Check | The default local user ‘Administrator’ is still de fined on the machine |
|
OS Audit Logon Attempts |
Health Check | Test user logon attempts |
|
OS Guest Disabled |
Health Check | Local user Guest is enabled |
|
OS Is NTFS |
Health Check | Any Drive nonNTFS format |
|
OS No Dev Tools |
Health Check | Development tools exist in the environment |
|
OS Null Session |
Health Check | The OS is allowing Null session access |
|
OS Only TCPIP |
Health Check | Active Network Card |
|
OS Remove Default Shares |
Health Check | Default shares are defined on the server machine |
|
OS Shutdown Privs |
Health Check | The shutdown privilege is given to all Users, which is a bad practice for important systems |
|
OS SQL Services Recommended Status |
Health Check | SQL Services Recommended Statuses Verified |
|
OS Too Many Shared |
Health Check | Too many shares are defined on the machine |
|
OS Unnecessary Users List |
Health Check | Too many local users were found on the machine |
|
Remote Accesses |
Health Check | Ensure ‘Remote Accesses’ Server Configuration Option is |
|
Remote Admin Connections |
Health Check | Ensure ‘Remote Admin Connections’ Server Con figuration Option is set to ‘0’ |
|
SQL C2 Auditing |
Health Check | C2 Audit Tracing is disabled for service |
|
SQL Clr On |
Health Check | clr operations are enabled on the server |
|
SQL DeadlLocfi Flag Disabled |
Health Check | SQL DeadlLock Flag Disabled |
|
SQL No Sample Databases |
Health Check | Sample DBs exist in an environment |
|
SQL Not Default Port |
Health Check | Verify not default port used |
|
SQL Only TCPIP |
Health Check | SQL Is Only In TCP\IP protocol |
|
SQL Password Columns |
Health Check | Suspicious column holding sensitive information. It should be considered for encryption. |
|
SQL Single Instance |
Health Check | Not more than one active SQL Server instance per machine |
|
SQL Too Many Have SA Privi leges |
Health Check | Too many defined logins with SA privileges |
|
SQL Windows Authentication |
Health Check | SQL Server Authentication is enabled |
|
SQL xp_cmdshell Enabled |
Health Check | xp_cmdshell is enabled |
|
Machine Any Drive Free Space |
Logical Drives | Drive free space is under @PARAM1 @PARAM2 |
| MachineSpecific Drive Free Space | Logical Drives | Drive @PARAM1 free space is under @PARAM2 @PARAM3 |
|
Machine Disfi Bytes Per Sec |
Logical Drives Per formance | logical partition ‘@PARAM1’ disk bytes per sec is above the value @PARAM2 |
|
Machine Disfi Reads Bytes Per Sec |
Logical Drives Per formance | logical partition ‘@PARAM1’ disk read bytes per sec is above the value @PARAM2 |
|
Machine Disfi Writes Bytes Per Sec |
Logical Drives Per formance | logical partition ‘@PARAM1’ disk write bytes per sec is above the value @PARAM2 |
| Free Physical Memory Below Threshold | Memory | Free memory is under @PARAM1 @PARAM2 |
| Machine SQL Process Memory Over Threshold | Memory | SQL Server memory usage is over @PARAM1 MB |
|
Agent Monitor SQL Connection Failed |
Monitor | Agent Monitor SQL Connection Failed |
|
Agent Monitor Stopped |
Monitor | Agent monitoring has stopped for more than @ PARAM1 minutes |
| Agent Monitor WMI Connection Failed | Monitor | Agent Monitor WMI Connection Failed |
|
Agent Monitoring Error |
Monitor | Agent Monitoring Error |
| Managed Server NonRespon sive | Monitor | Managed server negative ping response |
| Machine Process CPU Over Threshold | Process Per formance | Process @PARAM1 CPU % is above @PARAM2 |
| Machine Process Memory Over Threshold | Process Per formance | Process @PARAM1 Memory Consumption is above @PARAM2 |
| Machine Process Paging Over Threshold | Process Per formance | Alert if paging for process @PARAM1 is above @ PARAM2 MB |
| Machine SQL Process CPU Over Threshold | Process Per formance | SQL Server CPU usage is over @PARAM1 % |
| Machine AVG CPU Over Thresh old | Processor | average CPU is above @PARAM1% (AVG for last @PARAM2 minutes) |
| Machine Total CPU Over Threshold | Processor | CPU usage is above @PARAM1 % |
| Machine Total CPU Under Uti lized Threshold | Processor | CPU usage is below @PARAM1% |
|
Server Any Job Status |
Scheduled Operations | Any job execution has @PARAM1 |
| Server Any Job Status (With Excluded) | Scheduled Operations | Alert if ANY Job execution (excluded jobs: @ PARAM1) has changed status |
|
Server Job Duration Unusual |
Scheduled Operations | Alert if ANY Job duration is @PARAM1% longer than usual (min job duration: @PARAM2 seconds) |
|
ServerSpecific Job Status |
Scheduled Operations | One or more of SQL Jobs @PARAM1 execution has @PARAM2 |
|
Server Blocfiing Occured |
Server Diag nostics | Process is BLOCKING for over @PARAM1 sec onds |
|
Server Mode Locfi Monitor |
Server Diag nostics | @PARAM1 object LOCK occurs for over @ PARAM2 seconds |
|
Server Process Locfi Monitor |
Server Diag nostics | Process is LOCKING for over @PARAM1 seconds |
|
Server Type Locfi Monitor |
Server Diag nostics | @PARAM1 object is LOCKED for over @PARAM2 seconds |
|
SQL Agent Is Down |
Server Diag nostics | SQL server agent is down |
|
SQL Server Error Log Entry |
Server Diag nostics | SQL Server Error Log Entry |
|
SQL Service Is Down |
Server Diag nostics | SQL server service is down |