| DisplayName | Description | ID | Target | Parent Monitor | Category | Enabled | Instance Name | Counter Name | Frequency | Alert Generate | Alert Severity | Alert Priority | Alert Auto Resolve | Monitor Type | Remotable | Accessibility | RunAs |
| Long Running Jobs | This monitor checks for long running SQL Agent jobs. | Microsoft.SQLServer.2005.Agent.LongRunningJobs | Microsoft.SQLServer.2005.Agent | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2005.AgentLongRunningJobsProvider | True | Public | |
| SQL Server Agent Windows Service | This monitor checks the status of the SQL Agent service for this instance of SQL Server. | Microsoft.SQLServer.2005.Agent.ServiceMonitor | Microsoft.SQLServer.2005.Agent | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Windows.CheckNTServiceStateMonitorType | True | Public | |
| Job Duration | Monitors Agent Job Duration. | Microsoft.SQLServer.2005.AgentJob.JobDuration | Microsoft.SQLServer.2005.AgentJob | System.Health.PerformanceState | PerformanceCollection | True | | | 0 | False | | | True | Microsoft.SQLServer.2005.AgentLongRunningJobsProviderPerJob | True | Public | |
| Last Run Status | SQL 2005 Agent Job Last Run State Monitor. Monitors the last run state of an SQL Agent Job. | Microsoft.SQLServer.2005.AgentJob.JobLastRunState | Microsoft.SQLServer.2005.AgentJob | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.2005.AgentJobLastRunProvider | True | Public | |
| SQL Server Analysis Services Windows Service | This monitor checks the status of the SQL Analysis Services service. | Microsoft.SQLServer.2005.AnalysisServices.ServiceMonitor | Microsoft.SQLServer.2005.AnalysisServices | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Windows.CheckNTServiceStateMonitorType | True | Public | |
| Auto Close Configuration | Monitors the auto close setting for the database | Microsoft.SQLServer.2005.Database.Configuration.AutoClose | Microsoft.SQLServer.2005.Database | Microsoft.SQLServer.2005.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2005.DBConfigurationStatus | True | Public | |
| Auto Create Statistics Configuration | Monitors the auto create statistic setting for the database | Microsoft.SQLServer.2005.Database.Configuration.AutoCreateStat | Microsoft.SQLServer.2005.Database | Microsoft.SQLServer.2005.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2005.DBConfigurationStatus | True | Public | |
| Auto Shrink Configuration | Monitors the auto shrink setting for the database | Microsoft.SQLServer.2005.Database.Configuration.AutoShrink | Microsoft.SQLServer.2005.Database | Microsoft.SQLServer.2005.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2005.DBConfigurationStatus | True | Public | |
| Auto Update Statistics Configuration | Monitors the auto update statistics setting for the database | Microsoft.SQLServer.2005.Database.Configuration.AutoUpdateSet | Microsoft.SQLServer.2005.Database | Microsoft.SQLServer.2005.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2005.DBConfigurationStatus | True | Public | |
| Auto Update Statistics Async Configuration | Monitors the auto update statistics async setting for the database | Microsoft.SQLServer.2005.Database.Configuration.AutoUpdateStatAsync | Microsoft.SQLServer.2005.Database | Microsoft.SQLServer.2005.Database.AutomaticConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2005.DBConfigurationStatus | True | Public | |
| DB Chaining Configuration | Monitors the DB chaining setting for the database | Microsoft.SQLServer.2005.Database.Configuration.DBChaining | Microsoft.SQLServer.2005.Database | Microsoft.SQLServer.2005.Database.ExternalAccessConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2005.DBConfigurationStatus | True | Public | |
| Recovery Model Configuration | Monitors the recovery model setting for the database. | Microsoft.SQLServer.2005.Database.Configuration.RecoveryModel | Microsoft.SQLServer.2005.Database | Microsoft.SQLServer.2005.Database.RecoveryConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2005.DBConfigurationStatus | True | Public | |
| Page Verify Configuration | Monitors the page verify setting for the database. | Microsoft.SQLServer.2005.Database.Configuration.TornPageDetection | Microsoft.SQLServer.2005.Database | Microsoft.SQLServer.2005.Database.RecoveryConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2005.DBConfigurationStatus | True | Public | |
| Trustworthy Configuration | Monitors the trustworthy setting for the database | Microsoft.SQLServer.2005.Database.Configuration.TrustWorthy | Microsoft.SQLServer.2005.Database | Microsoft.SQLServer.2005.Database.ExternalAccessConfiguration | ConfigurationHealth | False | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.2005.DBConfigurationStatus | True | Public | |
| DB Space Free (MB) : DEPRECATED | This monitor is DEPRECATED. Monitors for the free space left in the database in terms of megabytes. | Microsoft.SQLServer.2005.Database.DBSizeMegabytesMonitor | Microsoft.SQLServer.2005.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | False | | | True | Microsoft.SQLServer.2005.DBAndLogSizeMonitorType | True | Public | |
| DB Space Percentage Change | Monitors for a large change in value of database available space over a set number of sample periods. | Microsoft.SQLServer.2005.Database.DBSizePercentageChangeMonitor | Microsoft.SQLServer.2005.Database | Microsoft.SQLServer.2005.Database.DBSpaceMonitor | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2005.DBPercentageChange | True | Public | |
| DB Total Space | Monitors the space available in the database and on the media hosting the database in percentage terms. | Microsoft.SQLServer.2005.Database.DBSizePercentMonitor | Microsoft.SQLServer.2005.Database | Microsoft.SQLServer.2005.Database.DBSpaceMonitor | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | High | True | Microsoft.SQLServer.2005.DBAndLogSizeMonitorType | True | Public | |
| Database Status | This monitor checks the status of the database as reported by Microsoft® SQL Server™. | Microsoft.SQLServer.2005.Database.DBStatusMonitor | Microsoft.SQLServer.2005.Database | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2005.DBStatus | True | Public | |
| Destination Log Shipping | 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. | Microsoft.SQLServer.2005.Database.LogShippingDestinationMonitor | Microsoft.SQLServer.2005.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Windows.2SingleEventLog2StateMonitorType | True | Public | |
| Source Log Shipping | 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. | Microsoft.SQLServer.2005.Database.LogShippingSourceMonitor | Microsoft.SQLServer.2005.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Windows.2SingleEventLog2StateMonitorType | True | Public | |
| SQL Server Windows Service | This monitor checks the status of the SQL Database Engine service. | Microsoft.SQLServer.2005.Database.ServiceMonitor | Microsoft.SQLServer.2005.Database | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.2005.CheckDBEngineServiceStateMonitorType | True | Public | |
| DB Log File Space Free (MB) : DEPRECATED | This monitor is DEPRECATED. Monitors the space available on the log files and on the media hosting the log files in megabytes. | Microsoft.SQLServer.2005.Database.TransactionLogSizeMegabytesMonitor | Microsoft.SQLServer.2005.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2005.DBAndLogSizeMonitorType | True | Public | |
| DB Log File Space Free (\%) : DEPRECATED | This monitor is DEPRECATED. Monitors the space available on the log files and on the media hosting the log in percentage terms. | Microsoft.SQLServer.2005.Database.TransactionLogSizePercentMonitor | Microsoft.SQLServer.2005.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2005.DBAndLogSizeMonitorType | True | Public | |
| Blocking Sessions | Monitors blocked sessions for a SQL instance. | Microsoft.SQLServer.2005.DBEngine.BlockedSPIDsMonitor | Microsoft.SQLServer.2005.DBEngine | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | Error | High | True | Microsoft.SQLServer.2005.DBEngine.BlockedSPIDs | True | Public | |
| Service Pack Compliance | Monitors the service pack level of the database engine against the compliant setting | Microsoft.SQLServer.2005.DBEngine.Configuration.ServicePackLevel | Microsoft.SQLServer.2005.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2005.ServicePackVersion | True | Public | |
| CPU Utilization (\%) | CPU Utilization (\%) for 2005 DB Engine | Microsoft.SQLServer.2005.DBEngine.CPUUsagePercentMonitor | Microsoft.SQLServer.2005.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2005.DBEngine.CPUUsagePercent.MonitorType | True | Public | |
| SQL Server Full Text Search Service | This monitor checks the status of the SQL Full Text Search service. | Microsoft.SQLServer.2005.DBEngine.FullTextSearchServiceMonitor | Microsoft.SQLServer.2005.DBEngine | System.Health.AvailabilityState | AvailabilityHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.Windows.CheckNTServiceStateMonitorType | True | Public | |
| SQL Server Windows Service | This monitor checks the status of the SQL Database Engine service. | Microsoft.SQLServer.2005.DBEngine.ServiceMonitor | Microsoft.SQLServer.2005.DBEngine | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2005.CheckWinServiceStateMonitorType | True | Public | |
| SQL User Connections Performance | This monitor analysis the user connections to the SQL database engine over time and calculates a baseline over the initial learning period. | Microsoft.SQLServer.2005.DBEngine.UserConnectionsBaselineMonitor | Microsoft.SQLServer.2005.DBEngine | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | System.Performance.TwoStateAboveBaseliningMonitorWithoutCompression | True | Public | |
| Disk Free Space : DEPRECATED | Monitors the free space percentage left on a disk drive. | Microsoft.SQLServer.2005.DBFile.DiskFreeSpace | Microsoft.SQLServer.2005.DBFile | System.Health.PerformanceState | PerformanceHealth | False | LogicalDisk | \% Free Space | 3600 | True | Error | Normal | True | System.Performance.ThresholdMonitorType | True | Public | |
| SQL Server Integration Services Windows Service | This monitor checks the status of the SQL Integration Services service. | Microsoft.SQLServer.2005.IntegrationServices.ServiceMonitor | Microsoft.SQLServer.2005.IntegrationServices | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Windows.CheckNTServiceStateMonitorType | True | Public | |
| DB File Space | Monitors the space available on a database file and on the media hosting the file in percentage terms. | Microsoft.SQLServer.2005.Monitoring.DBFileSpaceMonitor | Microsoft.SQLServer.2005.DBFile | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.2005.DBFileSizeMonitorType | True | Public | |
| DB Log File Space | Monitors the space available on a log file and on the media hosting the log in percentage terms. | Microsoft.SQLServer.2005.Monitoring.DBLogFileSpaceMonitor | Microsoft.SQLServer.2005.DBLogFile | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.2005.DBLogFileSizeMonitorType | True | Public | |
| SQL Server Reporting Services Windows Service | This monitor checks the status of the SQL Reporting Services service. | Microsoft.SQLServer.2005.ReportingServices.ServiceMonitor | Microsoft.SQLServer.2005.ReportingServices | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Windows.CheckNTServiceStateMonitorType | True | Public | |