Auto Close Configuration |
0
|
SQL Server 2012 DB
|
Auto Close Configuration Error |
Monitors the auto close setting for the database |
Auto Create Statistics Configuration |
0
|
SQL Server 2012 DB
|
Auto Create Statistics Configuration Error |
Monitors the auto create statistic setting for the database |
Auto Shrink Configuration |
0
|
SQL Server 2012 DB
|
Auto Shrink Configuration Error |
Monitors the auto shrink setting for the database |
Auto Update Statistics Async Configuration |
0
|
SQL Server 2012 DB
|
Auto Update Statistics Async Configuration Error |
Monitors the auto update statistics async setting for the database |
Auto Update Statistics Configuration |
0
|
SQL Server 2012 DB
|
Auto Update Statistics Configuration Error |
Monitors the auto update statistics setting for the database |
Availability Database Backup Status |
0
|
MSSQL 2012: Availability Database Health
|
|
The monitor checks availability of a full database backup and its age as reported by Microsoft SQL Server; it does not apply any logic regarding the replicas preferred for the backup. |
Availability Database Data Synchronization |
1
|
Database Replica
|
|
Availability Database Data Synchronization |
Availability Database Join State |
1
|
Database Replica
|
|
Availability Database Join State |
Availability Database Suspension State |
1
|
Database Replica
|
|
Availability Database Suspension State |
Availability Group Automatic Failover monitor |
1
|
Availability Group Health
|
|
Availability Group Automatic Failover |
Availability Group Health Policy |
1
|
Availability Group Critical Policy
|
|
Two state monitor with 'Error' critical state used particularly for reflecting state of Custom User Policies which have Availability Group as Facet and one of the predefined error categories as Policy Category. |
Availability Group Health Policy |
1
|
Availability Group Warning Policy
|
|
Two state monitor with 'Warning' critical state used particularly for reflecting state of Custom User Policies which have Availability Group as Facet and one of the predefined warning categories as Policy Category. |
Availability Group Online monitor |
1
|
Availability Group Health
|
|
Availability Group Online |
Availability Replica Connection |
1
|
Availability Replica
|
|
Availability Replica Connection |
Availability Replica Data Synchronization |
1
|
Availability Replica
|
|
Availability Replica Data Synchronization |
Availability Replica Health Policy |
1
|
Availability Replica Critical Policy
|
|
Two state monitor with 'Error' critical state used particularly for reflecting state of Custom User Policies which have Availability Replica as Facet and one of the predefined error categories as Policy Category. |
Availability Replica Health Policy |
1
|
Availability Replica Warning Policy
|
|
Two state monitor with 'Warning' critical state used particularly for reflecting state of Custom User Policies which have Availability Replica as Facet and one of the predefined warning categories as Policy Category. |
Availability Replica Join State |
1
|
Availability Replica
|
|
Availability Replica Join State |
Availability Replica Role |
1
|
Availability Replica
|
|
Availability Replica Role |
Availability Replicas Connection monitor |
1
|
Availability Group Health
|
|
Availability Replicas Connection |
Availability Replicas Data Synchronization monitor |
1
|
Availability Group Health
|
|
Availability Replicas Data Synchronization |
Availability Replicas Role monitor |
1
|
Availability Group Health
|
|
Availability Replicas Role |
Average Wait Time |
1
|
SQL Server 2012 DB Engine
|
SQL 2012 DB Average Wait Time is too high |
Average Wait Time monitor for 2012 Databases. |
Blocking Sessions |
0
|
SQL Server 2012 DB Engine
|
Blocked Session(s) |
Monitors blocked sessions for an SQL instance. |
Buffer Cache Hit Ratio |
1
|
SQL Server 2012 DB Engine
|
SQL DB Engine 2012 Buffer Cache Hit Ratio is too low |
Buffer Cache Hit Ratio for 2012 DB Engine |
CPU Utilization (%) |
1
|
SQL Server 2012 DB Engine
|
SQL DB Engine 2012 CPU Utilization (%) is too high |
CPU Utilization (%) for 2012 DB Engine |
Database Backup Status |
0
|
SQL Server 2012 DB
|
Database backup should be performed |
This monitor checks the status of the database backup as reported by Microsoft® SQL Server™. Note that the monitor ignores Always On databases. Therefore, it is always "green" for those databases. For backups of Always On databases, use the dedicated monitors at the Availability Group. |
Database Health Policy |
1
|
Database Critical Policy
|
|
Two state monitor with 'Error' critical state used particularly for reflecting state of Custom User Policies which have Database as Facet and one of the predefined error categories as Policy Category. |
Database Health Policy |
1
|
Database Warning Policy
|
|
Two state monitor with 'Warning' critical state used particularly for reflecting state of Custom User Policies which have Database as Facet and one of the predefined warning categories as Policy Category. |
Database Mirror Status |
1
|
SQL 2012 Mirrored DB
|
Database Mirror is not Synchronized |
This monitor checks if database mirror is synchronized. |
Database Mirror Witness Status |
1
|
SQL 2012 Mirrored DB
|
Database Mirror Witness is not accessible |
This monitor checks if database mirror witness is accessible. |
Database Mirroring Partners Status |
1
|
SQL 2012 Mirrored DB Witness
|
Database mirroring partners are not synchronized |
This monitor checks if database mirror is synchronized. |
Database Replica Health Policy |
1
|
Database Replica Critical Policy
|
|
Two state monitor with 'Error' critical state used particularly for reflecting state of Custom User Policies which have Database Replica State as Facet and one of the predefined error categories as Policy Category. |
Database Replica Health Policy |
1
|
Database Replica Warning Policy
|
|
Two state monitor with 'Warning' critical state used particularly for reflecting state of Custom User Policies which have Database Replica State as Facet and one of the predefined warning categories as Policy Category. |
Database Status |
1
|
SQL Server 2012 DB
|
Database Offline |
This monitor checks the status of the database as reported by Microsoft® SQL Server™. |
DB Chaining Configuration |
0
|
SQL Server 2012 DB
|
DB Chaining Configuration Error |
Monitors the DB chaining setting for the database |
DB File Space |
1
|
SQL Server 2012 DB File
|
|
Monitors the space available on a database file and on the media hosting the file in percentage terms. |
DB FILESTREAM Filegroup Free Space |
1
|
SQL Server 2012 DB FILESTREAM Filegroup
|
MSSQL 2012: DB FILESTREAM Filegroup data container is running out of space |
The monitor reports a warning when the free space drops below the Warning Threshold setting, expressed as percentage of the sum of data size. The monitor reports a critical alert when the free space drops below the Critical Threshold. |
DB Log File Space |
1
|
SQL Server 2012 DB Log File
|
|
Monitors the space available on a log file and on the media hosting the log in percentage terms. |
DB Space Percentage Change |
0
|
SQL Server 2012 DB
|
Significant Percentage Change in DB Total Free Space |
Monitors for a large change in value of database free space over a set number of sample periods. |
DB Total Space |
0
|
SQL Server 2012 DB
|
Database Out of Space |
Monitors the space available in the database and on the media hosting the database in percentage terms. Note that this monitor does not count free space for FILESTREAM Filegroups. |
Destination Log Shipping |
1
|
SQL Server 2012 DB
|
Log Shipping Destination |
This monitor detects when a log shipping destination has not had a log restored to it within the threshold defined as a part of the log shipping configuration.
Note that all Log Shipping is not supported by any edition of SQL Server Express. |
Disk Read Latency |
0
|
SQL Server 2012 DB
|
SQL DB 2012 disk read latency is too high |
Disk Read Latency monitor for 2012 Databases.
Note: This monitor is disabled by default. Please use overrides to enable it when necessary. |
Disk Write Latency |
0
|
SQL Server 2012 DB
|
SQL DB 2012 disk write latency is too high |
Disk Write Latency monitor for 2012 Databases.
Note: This monitor is disabled by default. Please use overrides to enable it when necessary. |
Job Duration |
1
|
SQL Server 2012 Agent Job
|
|
Monitors Agent Job Duration.
Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express; there is no appropriate discovered object. |
Last Run Status |
1
|
SQL Server 2012 Agent Job
|
|
SQL 2012 Agent Job Last Run State Monitor. Monitors the last run state of an SQL Agent Job.
Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express; there is no appropriate discovered object. |
Long Running Jobs |
0
|
SQL Server 2012 Agent
|
Long Running Jobs |
This monitor checks for long running SQL Agent jobs.
Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express; there is no appropriate discovered object. This monitor is disabled by default. Please use overrides to enable it when necessary. |
Page Life Expectancy |
1
|
SQL Server 2012 DB Engine
|
SQL DB Engine 2012 Page Life Expectancy is too low |
Page Life Expectancy (s) for 2012 DB Engine |
Page Verify Configuration |
0
|
SQL Server 2012 DB
|
Page Verify Configuration Error |
Monitors the page verify setting for the database. |
Recovery Model Configuration |
0
|
SQL Server 2012 DB
|
Recovery Model Configuration Error |
Monitors the recovery model setting for the database. |
Service Pack Compliance |
1
|
SQL Server 2012 DB Engine
|
Service Pack Compliance |
Monitors the service pack level of the database engine against the compliant setting |
Service Principal Name Configuration Status |
1
|
SQL Server 2012 DB Engine
|
SQL Server cannot authenticate using Kerberos because the Service Principal Name (SPN) is missing, misplaced, or duplicated. |
This monitor checks the status of the Microsoft® SQL Server™ instance Service Principal Name configuration.
Note that the monitor is always in "Healthy" state for non-domain joined machines. |
Source Log Shipping |
1
|
SQL Server 2012 DB
|
Log Shipping Source |
This monitor detects when a log shipping source has not had its logs backed up within the threshold defined as a part of the log shipping configuration.
Note that all Log Shipping is not supported by any edition of SQL Server Express. |
SQL Full-text Filter Daemon Launcher Service |
0
|
SQL Server 2012 DB Engine
|
SQL Full-text Filter Daemon Launcher Service Stopped |
This monitor checks the status of the SQL Full-text Filter Daemon Launcher service. Note that SQL Full-text Search feature is not available in any edition of SQL Server Express, except SQL Server Express with Advanced Services. This monitor is disabled by default. Please use overrides to enable it when necessary. |
SQL Re-Compilation |
0
|
SQL Server 2012 DB Engine
|
SQL DB 2012 SQL Re-Compilation is too high |
SQL Re-Compilation for 2012 DB Engine |
SQL Server Agent Windows Service |
1
|
SQL Server 2012 Agent
|
SQL Server Agent Windows Stopped |
This monitor checks the status of the SQL Agent service for this instance of SQL Server.
Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express. |
SQL Server Analysis Services Windows Service |
1
|
SQL Server 2012 Analysis Services
|
SQL Server Analysis Services Windows Stopped |
This monitor checks the status of the SQL Analysis Services service.
Note that SQL Analysis Services service is not supported by any edition of SQL Server Express. |
SQL Server Integration Services Windows Service |
1
|
SQL Server 2012 Integration Services
|
SQL Server Integration Services Windows Service Stopped |
This monitor checks the status of the SQL Integration Services service.
Note that all SQL Express editions support only SQL Server Import and Export Wizard, along with Built-in data source connectors. There is no appropriate discovered object (service). |
SQL Server Reporting Services Windows Service |
1
|
SQL Server 2012 Reporting Services
|
SQL Server Reporting Services Stopped |
This monitor checks the status of the SQL Reporting Services service.
Note that SQL Server Reporting Services Windows service is not supported by any edition of SQL Server Express, except SQL Server Express with Advanced Services. |
SQL Server Windows Service |
1
|
SQL Server 2012 DB Engine
|
SQL Server Service Stopped |
This monitor checks the status of the SQL Database Engine service. |
SQL Server Windows Service |
1
|
SQL Server 2012 DB
|
|
This monitor checks the status of the SQL Database Engine service. |
SQL User Connections Performance |
0
|
SQL Server 2012 DB Engine
|
SQL User Connections Abnormal |
This monitor analysis the user connections to the SQL database engine over time, and calculates a baseline over the initial learning period. |
Stolen Server Memory |
1
|
SQL Server 2012 DB Engine
|
SQL DB 2012 Engine Stolen Server Memory is too high |
Stolen Server Memory for 2012 DB Engine |
Synchronous Replicas Data Synchronization monitor |
1
|
Availability Group Health
|
|
Synchronous Replicas Data Synchronization |
Thread Count |
1
|
SQL Server 2012 DB Engine
|
SQL DB 2012 Engine Thread Count is too high |
Thread Count for 2012 DB Engine |
Transaction Log Free Space (%) |
0
|
SQL Server 2012 DB
|
SQL DB 2012 Transaction Log Free Space (%) is too low |
Transaction Log Free Space (%) monitor for 2012 Databases. |
Trustworthy Configuration |
0
|
SQL Server 2012 DB
|
Trustworthy Configuration Error |
Monitors the trustworthy setting for the database |
WSFC Cluster monitor |
1
|
Availability Group Health
|
|
WSFC Cluster monitor |