| 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 | | Microsoft.SQLServer.2008.Agent.LongRunningJobs | Microsoft.SQLServer.2008.Agent | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2008.AgentLongRunningJobsProvider | True | Public | |
| SQL Server Agent Windows Service | | Microsoft.SQLServer.2008.Agent.ServiceMonitor | Microsoft.SQLServer.2008.Agent | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Windows.CheckNTServiceStateMonitorType | True | Public | |
| Job Duration | | Microsoft.SQLServer.2008.AgentJob.JobDuration | Microsoft.SQLServer.2008.AgentJob | System.Health.PerformanceState | PerformanceCollection | True | | | 0 | False | | | True | Microsoft.SQLServer.2008.AgentLongRunningJobsProviderPerJob | True | Public | |
| Last Run Status | | Microsoft.SQLServer.2008.AgentJob.JobLastRunState | Microsoft.SQLServer.2008.AgentJob | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.2008.AgentJobLastRunProvider | True | Public | |
| SQL Server Analysis Services Windows Service | | Microsoft.SQLServer.2008.AnalysisServices.ServiceMonitor | Microsoft.SQLServer.2008.AnalysisServices | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Windows.CheckNTServiceStateMonitorType | True | Public | |
| Auto Close Flag | Monitors the auto close flag on the database | Microsoft.SQLServer.2008.Database.Configuration.AutoClose | Microsoft.SQLServer.2008.Database | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2008.DBConfigurationStatus | True | Public | |
| Auto Create Statistics Flag | Monitors the automatically create statistics flag on the database | Microsoft.SQLServer.2008.Database.Configuration.AutoCreateStat | Microsoft.SQLServer.2008.Database | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2008.DBConfigurationStatus | True | Public | |
| Auto Shrink Flag | Monitors the auto shrink flag on the database | Microsoft.SQLServer.2008.Database.Configuration.AutoShrink | Microsoft.SQLServer.2008.Database | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2008.DBConfigurationStatus | True | Public | |
| Auto Update Flag | Monitors the auto update flag on the database | Microsoft.SQLServer.2008.Database.Configuration.AutoUpdateSet | Microsoft.SQLServer.2008.Database | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2008.DBConfigurationStatus | True | Public | |
| DB Chaining Flag | Monitors the database chaining flag on the database | Microsoft.SQLServer.2008.Database.Configuration.DBChaining | Microsoft.SQLServer.2008.Database | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2008.DBConfigurationStatus | True | Public | |
| Torn Page Detection | | Microsoft.SQLServer.2008.Database.Configuration.TornPageDetection | Microsoft.SQLServer.2008.Database | System.Health.ConfigurationState | ConfigurationHealth | False | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2008.DBConfigurationStatus | True | Public | |
| DB Space Free (MB) | Monitors for the free space left in the database in terms of megabytes. | Microsoft.SQLServer.2008.Database.DBSizeMegabytesMonitor | Microsoft.SQLServer.2008.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2008.DBAndLogSizeMonitorType | True | Public | |
| Percentage Change in DB \% Used Space | Monitors for a large change in value of DB used space over a set number of sample periods. A rapid large change in value could indicate a problem | Microsoft.SQLServer.2008.Database.DBSizePercentageChangeMonitor | Microsoft.SQLServer.2008.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2008.DBPercentageChange | True | Public | |
| DB Space Free (\%) | Monitors for the free space left in the database in percentage terms. | Microsoft.SQLServer.2008.Database.DBSizePercentMonitor | Microsoft.SQLServer.2008.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2008.DBAndLogSizeMonitorType | True | Public | |
| Database Status | | Microsoft.SQLServer.2008.Database.DBStatusMonitor | Microsoft.SQLServer.2008.Database | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2008.DBStatus | True | Public | |
| Destination Log Shipping Monitor | | Microsoft.SQLServer.2008.Database.LogShippingDestinationMonitor | Microsoft.SQLServer.2008.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Windows.2SingleEventLog2StateMonitorType | True | Public | |
| Source Log Shipping Monitor | | Microsoft.SQLServer.2008.Database.LogShippingSourceMonitor | Microsoft.SQLServer.2008.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Windows.2SingleEventLog2StateMonitorType | True | Public | |
| Transaction Log Space Free (MB) | Monitors for the free space left in the transaction log in percentage terms. | Microsoft.SQLServer.2008.Database.TransactionLogSizeMegabytesMonitor | Microsoft.SQLServer.2008.Database | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2008.DBAndLogSizeMonitorType | True | Public | |
| Transaction Log Space Free (\%) | Monitors for the free space left in the transaction log in percentage terms. | Microsoft.SQLServer.2008.Database.TransactionLogSizePercentMonitor | Microsoft.SQLServer.2008.Database | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | MatchMonitorHealth | Normal | True | Microsoft.SQLServer.2008.DBAndLogSizeMonitorType | True | Public | |
| Blocking SPIDs | | Microsoft.SQLServer.2008.DBEngine.BlockedSPIDsMonitor | Microsoft.SQLServer.2008.DBEngine | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | False | | | True | Microsoft.SQLServer.2008.DBEngine.BlockedSPIDs | True | Public | |
| Service Pack Compliance | Monitors the service pack level of the database engine against the compliant setting | Microsoft.SQLServer.2008.DBEngine.Configuration.ServicePackLevel | Microsoft.SQLServer.2008.DBEngine | System.Health.ConfigurationState | ConfigurationHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.2008.ServicePackVersion | True | Public | |
| SQL Server Full Text Search Service Monitor | | Microsoft.SQLServer.2008.DBEngine.FullTextSearchServiceMonitor | Microsoft.SQLServer.2008.DBEngine | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Windows.CheckNTServiceStateMonitorType | True | Public | |
| SQL Server Windows Service | | Microsoft.SQLServer.2008.DBEngine.ServiceMonitor | Microsoft.SQLServer.2008.DBEngine | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Windows.CheckNTServiceStateMonitorType | True | Public | |
| SQL User Connections Performance | | Microsoft.SQLServer.2008.DBEngine.UserConnectionsBaselineMonitor | Microsoft.SQLServer.2008.DBEngine | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | Error | Normal | True | System.Performance.TwoStateAboveBaseliningMonitorWithoutCompression | True | Public | |
| Disk Free Space | | Microsoft.SQLServer.2008.DBFile.DiskFreeSpace | Microsoft.SQLServer.2008.DBFile | System.Health.PerformanceState | PerformanceHealth | True | LogicalDisk | \% Free Space | 3600 | True | Error | Normal | True | System.Performance.ThresholdMonitorType | True | Public | |
| SQL Server Integration Services Windows Service | | Microsoft.SQLServer.2008.IntegrationServices.ServiceMonitor | Microsoft.SQLServer.2008.IntegrationServices | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Windows.CheckNTServiceStateMonitorType | True | Public | |
| SQL Server Reporting Services Windows Service | | Microsoft.SQLServer.2008.ReportingServices.ServiceMonitor | Microsoft.SQLServer.2008.ReportingServices | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.Windows.CheckNTServiceStateMonitorType | True | Public | |