All Unit Monitors in Microsoft.SQLServer.2008.Monitoring Management Pack

	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.2008.Agent.LongRunningJobs	Microsoft.SQLServer.2008.Agent	System.Health.PerformanceState	PerformanceHealth	False			0	True	MatchMonitorHealth	Normal	True	Microsoft.SQLServer.2008.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.2008.Agent.ServiceMonitor	Microsoft.SQLServer.2008.Agent	System.Health.AvailabilityState	AvailabilityHealth	True			0	True	Error	Normal	True	Microsoft.Windows.CheckNTServiceStateMonitorType	True	Public
	Job Duration	Monitors Agent 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	SQL 2008 Agent Job Last Run State Monitor. Monitors the last run state of an SQL Agent Job.	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	This monitor checks the status of the SQL Analysis Services 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 Configuration	Monitors the auto close setting for the database	Microsoft.SQLServer.2008.Database.Configuration.AutoClose	Microsoft.SQLServer.2008.Database	Microsoft.SQLServer.2008.Database.AutomaticConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2008.DBConfigurationStatus	True	Public
	Auto Create Statistics Configuration	Monitors the auto create statistic setting for the database	Microsoft.SQLServer.2008.Database.Configuration.AutoCreateStat	Microsoft.SQLServer.2008.Database	Microsoft.SQLServer.2008.Database.AutomaticConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2008.DBConfigurationStatus	True	Public
	Auto Shrink Configuration	Monitors the auto shrink setting for the database	Microsoft.SQLServer.2008.Database.Configuration.AutoShrink	Microsoft.SQLServer.2008.Database	Microsoft.SQLServer.2008.Database.AutomaticConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2008.DBConfigurationStatus	True	Public
	Auto Update Statistics Configuration	Monitors the auto update statistics setting for the database	Microsoft.SQLServer.2008.Database.Configuration.AutoUpdateSet	Microsoft.SQLServer.2008.Database	Microsoft.SQLServer.2008.Database.AutomaticConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2008.DBConfigurationStatus	True	Public
	Auto Update Statistics Async Configuration	Monitors the auto update statistics async setting for the database	Microsoft.SQLServer.2008.Database.Configuration.AutoUpdateStatAsync	Microsoft.SQLServer.2008.Database	Microsoft.SQLServer.2008.Database.AutomaticConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2008.DBConfigurationStatus	True	Public
	DB Chaining Configuration	Monitors the DB chaining setting for the database	Microsoft.SQLServer.2008.Database.Configuration.DBChaining	Microsoft.SQLServer.2008.Database	Microsoft.SQLServer.2008.Database.ExternalAccessConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2008.DBConfigurationStatus	True	Public
	Recovery Model Configuration	Monitors the recovery model setting for the database.	Microsoft.SQLServer.2008.Database.Configuration.RecoveryModel	Microsoft.SQLServer.2008.Database	Microsoft.SQLServer.2008.Database.RecoveryConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2008.DBConfigurationStatus	True	Public
	Page Verify Configuration	Monitors the page verify setting for the database.	Microsoft.SQLServer.2008.Database.Configuration.TornPageDetection	Microsoft.SQLServer.2008.Database	Microsoft.SQLServer.2008.Database.RecoveryConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2008.DBConfigurationStatus	True	Public
	Trustworthy Configuration	Monitors the trustworthy setting for the database	Microsoft.SQLServer.2008.Database.Configuration.TrustWorthy	Microsoft.SQLServer.2008.Database	Microsoft.SQLServer.2008.Database.ExternalAccessConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2008.DBConfigurationStatus	True	Public
	Database Backup Status	This monitor checks the status of the database backup as reported by Microsoft® SQL Server™.	Microsoft.SQLServer.2008.Database.DBBackupStatusMonitor	Microsoft.SQLServer.2008.Database	System.Health.AvailabilityState	AvailabilityHealth	False			0	True	Error	Normal	True	Microsoft.SQLServer.2008.DBBackupStatus	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.2008.Database.DBSizeMegabytesMonitor	Microsoft.SQLServer.2008.Database	System.Health.PerformanceState	PerformanceHealth	False			0	False			True	Microsoft.SQLServer.2008.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.2008.Database.DBSizePercentageChangeMonitor	Microsoft.SQLServer.2008.Database	Microsoft.SQLServer.2008.Database.DBSpaceMonitor	PerformanceHealth	False			0	True	MatchMonitorHealth	Normal	True	Microsoft.SQLServer.2008.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.2008.Database.DBSizePercentMonitor	Microsoft.SQLServer.2008.Database	Microsoft.SQLServer.2008.Database.DBSpaceMonitor	PerformanceHealth	False			0	True	MatchMonitorHealth	High	True	Microsoft.SQLServer.2008.DBAndLogSizeMonitorType	True	Public
	Database Status	This monitor checks the status of the database as reported by Microsoft® SQL Server™.	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
	Disk Read Latency	Disk Read Latency monitor for 2008 DBs	Microsoft.SQLServer.2008.Database.DiskReadLatencyMonitor	Microsoft.SQLServer.2008.Database	System.Health.PerformanceState	PerformanceHealth	False			0	True	Error	Normal	True	Microsoft.SQLServer.2008.Database.DiskReadLatency.MonitorType	True	Public
	Disk Write Latency	Disk Write Latency monitor for 2008 DBs	Microsoft.SQLServer.2008.Database.DiskWriteLatencyMonitor	Microsoft.SQLServer.2008.Database	System.Health.PerformanceState	PerformanceHealth	False			0	True	Error	Normal	True	Microsoft.SQLServer.2008.Database.DiskWriteLatency.MonitorType	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.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	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.2008.Database.LogShippingSourceMonitor	Microsoft.SQLServer.2008.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.2008.Database.ServiceMonitor	Microsoft.SQLServer.2008.Database	System.Health.AvailabilityState	AvailabilityHealth	True			0	False			True	Microsoft.SQLServer.2008.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.2008.Database.TransactionLogSizeMegabytesMonitor	Microsoft.SQLServer.2008.Database	Microsoft.SQLServer.2008.Database.DBSpaceMonitor	PerformanceHealth	False			0	True	MatchMonitorHealth	Normal	True	Microsoft.SQLServer.2008.DBAndLogSizeMonitorType	True	Public
	DB Log File Space Free (\%)	Monitors the space available on the log files and on the media hosting the log in percentage terms.	Microsoft.SQLServer.2008.Database.TransactionLogSizePercentMonitor	Microsoft.SQLServer.2008.Database	Microsoft.SQLServer.2008.Database.DBSpaceMonitor	PerformanceHealth	False			0	True	MatchMonitorHealth	Normal	True	Microsoft.SQLServer.2008.DBAndLogSizeMonitorType	True	Public
	Average Wait Time	Average Wait Time monitor for 2008 DBs	Microsoft.SQLServer.2008.DBEngine.AverageWaitTimeMonitor	Microsoft.SQLServer.2008.DBEngine	System.Health.PerformanceState	PerformanceHealth	True			0	True	Warning	Normal	True	Microsoft.SQLServer.2008.DBEngine.AverageWaitTime.MonitorType	True	Public
	Blocking Sessions	Monitors blocked sessions for a SQL instance.	Microsoft.SQLServer.2008.DBEngine.BlockedSPIDsMonitor	Microsoft.SQLServer.2008.DBEngine	System.Health.PerformanceState	PerformanceHealth	False			0	True	Error	High	True	Microsoft.SQLServer.2008.DBEngine.BlockedSPIDs	True	Public
	Buffer Cache Hit Ratio	Buffer Cache Hit Ratio for 2008 DB Engine	Microsoft.SQLServer.2008.DBEngine.BufferCacheHitRatioMonitor	Microsoft.SQLServer.2008.DBEngine	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2008.DBEngine.BufferCacheHitRatio.MonitorType	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	MatchMonitorHealth	Normal	True	Microsoft.SQLServer.2008.ServicePackVersion	True	Public
	Service Principal Name Configuration Status	This monitor checks the status of the Microsoft® SQL Server™ instance Service Principal Name configuration.	Microsoft.SQLServer.2008.DBEngine.Configuration.SPNStatusMonitor	Microsoft.SQLServer.2008.DBEngine	System.Health.ConfigurationState	AvailabilityHealth	True			0	True	Warning	Normal	True	Microsoft.SQLServer.2008.DBEngine.Configuration.SPNStatus	True	Public
	CPU Utilization (\%)	CPU Utilization (\%) for 2008 DB Engine	Microsoft.SQLServer.2008.DBEngine.CPUUsagePercentMonitor	Microsoft.SQLServer.2008.DBEngine	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2008.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.2008.DBEngine.FullTextSearchServiceMonitor	Microsoft.SQLServer.2008.DBEngine	System.Health.AvailabilityState	AvailabilityHealth	False			0	True	MatchMonitorHealth	Normal	True	Microsoft.Windows.CheckNTServiceStateMonitorType	True	Public
	Page Life Expectancy	Page Life Expectancy (s) for 2008 DB Engine	Microsoft.SQLServer.2008.DBEngine.PageLifeExpectancyMonitor	Microsoft.SQLServer.2008.DBEngine	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2008.DBEngine.PageLifeExpectancy.MonitorType	True	Public
	SQL Server Windows Service	This monitor checks the status of the SQL Database Engine service.	Microsoft.SQLServer.2008.DBEngine.ServiceMonitor	Microsoft.SQLServer.2008.DBEngine	System.Health.AvailabilityState	AvailabilityHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2008.CheckWinServiceStateMonitorType	True	Public
	SQL Re-Compilation	SQL Re-Compilation for 2008 DB Engine	Microsoft.SQLServer.2008.DBEngine.SQLReCompilationMonitor	Microsoft.SQLServer.2008.DBEngine	System.Health.PerformanceState	PerformanceHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2008.DBEngine.SQLReCompilation.MonitorType	True	Public
	Stolen Server Memory	Stolen Server Memory for 2008 DB Engine	Microsoft.SQLServer.2008.DBEngine.StolenServerMemoryMonitor	Microsoft.SQLServer.2008.DBEngine	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2008.DBEngine.StolenServerMemory.MonitorType	True	Public
	Thread Count	Thread Count for 2008 DB Engine	Microsoft.SQLServer.2008.DBEngine.ThreadCountMonitor	Microsoft.SQLServer.2008.DBEngine	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2008.DBEngine.ThreadCount.MonitorType	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.2008.DBEngine.UserConnectionsBaselineMonitor	Microsoft.SQLServer.2008.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.2008.DBFile.DiskFreeSpace	Microsoft.SQLServer.2008.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.2008.IntegrationServices.ServiceMonitor	Microsoft.SQLServer.2008.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.2008.Monitoring.DBFileSpaceMonitor	Microsoft.SQLServer.2008.DBFile	System.Health.PerformanceState	PerformanceHealth	True			0	False			True	Microsoft.SQLServer.2008.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.2008.Monitoring.DBLogFileSpaceMonitor	Microsoft.SQLServer.2008.DBLogFile	System.Health.PerformanceState	PerformanceHealth	True			0	False			True	Microsoft.SQLServer.2008.DBLogFileSizeMonitorType	True	Public
	SQL Server Reporting Services Windows Service	This monitor checks the status of the SQL Reporting Services 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