Auto Close Configuration |
0
|
SQL Server 2008 DB
|
Auto Close Configuration Error |
Monitors the auto close setting for the database |
Auto Create Statistics Configuration |
0
|
SQL Server 2008 DB
|
Auto Create Statistics Configuration Error |
Monitors the auto create statistic setting for the database |
Auto Shrink Configuration |
0
|
SQL Server 2008 DB
|
Auto Shrink Configuration Error |
Monitors the auto shrink setting for the database |
Auto Update Statistics Async Configuration |
0
|
SQL Server 2008 DB
|
Auto Update Statistics Async Configuration Error |
Monitors the auto update statistics async setting for the database |
Auto Update Statistics Configuration |
0
|
SQL Server 2008 DB
|
Auto Update Statistics Configuration Error |
Monitors the auto update statistics setting for the database |
Blocking Sessions |
0
|
SQL Server 2008 DB Engine
|
Blocked Session(s) |
Monitors blocked sessions for a SQL instance. |
Database Backup Status |
0
|
SQL Server 2008 DB
|
Database backup should be performed |
This monitor checks the status of the database backup as reported by Microsoft® SQL Server™. |
Database Mirror Status |
1
|
SQL 2008 Mirrored DB
|
Database Mirror is not Synchronized |
This monitor checks if database mirror is synchronized. |
Database Mirror Witness Status |
1
|
SQL 2008 Mirrored DB
|
Database Mirror Witness is not accessible |
This monitor checks if database mirror witness is accessible. |
Database Mirroring Partners Status |
1
|
SQL 2008 Mirrored DB Witness
|
Database mirroring partners are not synchronized |
This monitor checks if database mirror is synchronized. |
Database Status |
1
|
SQL Server 2008 DB
|
Database Offline |
This monitor checks the status of the database as reported by Microsoft® SQL Server™. |
DB Chaining Configuration |
0
|
SQL Server 2008 DB
|
DB Chaining Configuration Error |
Monitors the DB chaining setting for the database |
DB File Space |
1
|
SQL Server 2008 DB File
|
|
Monitors the space available on a database file and on the media hosting the file in percentage terms. |
DB Log File Space |
1
|
SQL Server 2008 DB Log File
|
|
Monitors the space available on a log file and on the media hosting the log in percentage terms. |
DB Log File Space Free (%) : DEPRECATED |
0
|
SQL Server 2008 DB
|
Log Files Out of Space |
This monitor is DEPRECATED. Monitors the space available on the log files and on the media hosting the log in percentage terms. |
DB Log File Space Free (MB) : DEPRECATED |
0
|
SQL Server 2008 DB
|
Log Files Out of Space |
This monitor is DEPRECATED. Monitors the space available on the log files and on the media hosting the log files in megabytes. |
DB Space Free (MB) : DEPRECATED |
0
|
SQL Server 2008 DB
|
|
This monitor is DEPRECATED. Monitors for the free space left in the database in terms of megabytes. |
DB Space Percentage Change |
0
|
SQL Server 2008 DB
|
Significant Percentage Change in DB Total Free Space |
Monitors for a large change in value of database available space over a set number of sample periods. |
DB Total Space |
0
|
SQL Server 2008 DB
|
Database Out of Space |
Monitors the space available in the database and on the media hosting the database in percentage terms. |
Destination Log Shipping |
1
|
SQL Server 2008 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. |
Disk Free Space : DEPRECATED |
0
|
SQL Server 2008 DB File
|
Disk Space Is Getting Low |
Monitors the free space percentage left on a disk drive. |
Job Duration |
1
|
SQL Server 2008 Agent Job
|
|
Monitors Agent Job Duration. |
Last Run Status |
1
|
SQL Server 2008 Agent Job
|
|
SQL 2008 Agent Job Last Run State Monitor. Monitors the last run state of an SQL Agent Job. |
Long Running Jobs |
0
|
SQL Server 2008 Agent
|
Long Running Jobs |
This monitor checks for long running SQL Agent jobs. |
Page Verify Configuration |
0
|
SQL Server 2008 DB
|
Page Verify Configuration Error |
Monitors the page verify setting for the database. |
Recovery Model Configuration |
0
|
SQL Server 2008 DB
|
Recovery Model Configuration Error |
Monitors the recovery model setting for the database. |
Service Pack Compliance |
1
|
SQL Server 2008 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 2008 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. |
Source Log Shipping |
1
|
SQL Server 2008 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. |
SQL Server Agent Windows Service |
1
|
SQL Server 2008 Agent
|
SQL Server Agent Windows Stopped |
This monitor checks the status of the SQL Agent service for this instance of SQL Server. |
SQL Server Analysis Services Windows Service |
1
|
SQL Server 2008 Analysis Services
|
SQL Server Analysis Services Windows Stopped |
This monitor checks the status of the SQL Analysis Services service. |
SQL Server Full Text Search Service |
0
|
SQL Server 2008 DB Engine
|
SQL Server Full Text Search Service Stopped |
This monitor checks the status of the SQL Full Text Search service. |
SQL Server Integration Services Windows Service |
1
|
SQL Server 2008 Integration Services
|
SQL Server Integration Services Windows Service Stopped |
This monitor checks the status of the SQL Integration Services service. |
SQL Server Reporting Services Windows Service |
1
|
SQL Server 2008 Reporting Services
|
SQL Server Reporting Services Stopped |
This monitor checks the status of the SQL Reporting Services service. |
SQL Server Windows Service |
1
|
SQL Server 2008 DB Engine
|
SQL Server Service Stopped |
This monitor checks the status of the SQL Database Engine service. |
SQL Server Windows Service |
1
|
SQL Server 2008 DB
|
|
This monitor checks the status of the SQL Database Engine service. |
SQL User Connections Performance |
0
|
SQL Server 2008 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. |
Trustworthy Configuration |
0
|
SQL Server 2008 DB
|
Trustworthy Configuration Error |
Monitors the trustworthy setting for the database |