All Unit Monitors in Microsoft.SQLServer.2012.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.2012.Agent.LongRunningJobs	Microsoft.SQLServer.2012.Agent	System.Health.PerformanceState	PerformanceHealth	False			0	True	MatchMonitorHealth	Normal	True	Microsoft.SQLServer.2012.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.2012.Agent.ServiceMonitor	Microsoft.SQLServer.2012.Agent	System.Health.AvailabilityState	AvailabilityHealth	True			0	True	Error	Normal	True	Microsoft.Windows.CheckNTServiceStateMonitorType	True	Public
	Job Duration	Monitors Agent Job Duration.	Microsoft.SQLServer.2012.AgentJob.JobDuration	Microsoft.SQLServer.2012.AgentJob	System.Health.PerformanceState	PerformanceCollection	True			0	False			True	Microsoft.SQLServer.2012.AgentLongRunningJobsProviderPerJob	True	Public
	Last Run Status	SQL 2012 Agent Job Last Run State Monitor. Monitors the last run state of an SQL Agent Job.	Microsoft.SQLServer.2012.AgentJob.JobLastRunState	Microsoft.SQLServer.2012.AgentJob	System.Health.AvailabilityState	AvailabilityHealth	True			0	False			True	Microsoft.SQLServer.2012.AgentJobLastRunProvider	True	Public
	SQL Server Analysis Services Windows Service	This monitor checks the status of the SQL Analysis Services service.	Microsoft.SQLServer.2012.AnalysisServices.ServiceMonitor	Microsoft.SQLServer.2012.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.2012.Database.Configuration.AutoClose	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.Database.AutomaticConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2012.DBConfigurationStatus	True	Public
	Auto Create Statistics Configuration	Monitors the auto create statistic setting for the database	Microsoft.SQLServer.2012.Database.Configuration.AutoCreateStat	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.Database.AutomaticConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2012.DBConfigurationStatus	True	Public
	Auto Shrink Configuration	Monitors the auto shrink setting for the database	Microsoft.SQLServer.2012.Database.Configuration.AutoShrink	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.Database.AutomaticConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2012.DBConfigurationStatus	True	Public
	Auto Update Statistics Configuration	Monitors the auto update statistics setting for the database	Microsoft.SQLServer.2012.Database.Configuration.AutoUpdateSet	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.Database.AutomaticConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2012.DBConfigurationStatus	True	Public
	Auto Update Statistics Async Configuration	Monitors the auto update statistics async setting for the database	Microsoft.SQLServer.2012.Database.Configuration.AutoUpdateStatAsync	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.Database.AutomaticConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2012.DBConfigurationStatus	True	Public
	DB Chaining Configuration	Monitors the DB chaining setting for the database	Microsoft.SQLServer.2012.Database.Configuration.DBChaining	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.Database.ExternalAccessConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2012.DBConfigurationStatus	True	Public
	Recovery Model Configuration	Monitors the recovery model setting for the database.	Microsoft.SQLServer.2012.Database.Configuration.RecoveryModel	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.Database.RecoveryConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2012.DBConfigurationStatus	True	Public
	Page Verify Configuration	Monitors the page verify setting for the database.	Microsoft.SQLServer.2012.Database.Configuration.TornPageDetection	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.Database.RecoveryConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2012.DBConfigurationStatus	True	Public
	Trustworthy Configuration	Monitors the trustworthy setting for the database	Microsoft.SQLServer.2012.Database.Configuration.TrustWorthy	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.Database.ExternalAccessConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2012.DBConfigurationStatus	True	Public
	Database Backup Status	This monitor checks the status of the database backup as reported by Microsoft® SQL Server™.	Microsoft.SQLServer.2012.Database.DBBackupStatusMonitor	Microsoft.SQLServer.2012.Database	System.Health.AvailabilityState	AvailabilityHealth	False			0	True	Error	Normal	True	Microsoft.SQLServer.2012.DBBackupStatus	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.2012.Database.DBSizePercentageChangeMonitor	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.Database.DBSpaceMonitor	PerformanceHealth	False			0	True	MatchMonitorHealth	Normal	True	Microsoft.SQLServer.2012.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.2012.Database.DBSizePercentMonitor	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.Database.DBSpaceMonitor	PerformanceHealth	False			0	True	MatchMonitorHealth	High	True	Microsoft.SQLServer.2012.DBAndLogSizeMonitorType	True	Public
	Database Status	This monitor checks the status of the database as reported by Microsoft® SQL Server™.	Microsoft.SQLServer.2012.Database.DBStatusMonitor	Microsoft.SQLServer.2012.Database	System.Health.AvailabilityState	AvailabilityHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2012.DBStatus	True	Public
	Disk Read Latency	Disk Read Latency monitor for 2012 DBs	Microsoft.SQLServer.2012.Database.DiskReadLatencyMonitor	Microsoft.SQLServer.2012.Database	System.Health.PerformanceState	PerformanceHealth	False			0	True	Error	Normal	True	Microsoft.SQLServer.2012.Database.DiskReadLatency.MonitorType	True	Public
	Disk Write Latency	Disk Write Latency monitor for 2012 DBs	Microsoft.SQLServer.2012.Database.DiskWriteLatencyMonitor	Microsoft.SQLServer.2012.Database	System.Health.PerformanceState	PerformanceHealth	False			0	True	Error	Normal	True	Microsoft.SQLServer.2012.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.2012.Database.LogShippingDestinationMonitor	Microsoft.SQLServer.2012.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.2012.Database.LogShippingSourceMonitor	Microsoft.SQLServer.2012.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.2012.Database.ServiceMonitor	Microsoft.SQLServer.2012.Database	System.Health.AvailabilityState	AvailabilityHealth	True			0	False			True	Microsoft.SQLServer.2012.CheckDBEngineServiceStateMonitorType	True	Public
	Transaction Log Free Space (\%)	Transaction Log Free Space (\%) monitor for 2012 DBs	Microsoft.SQLServer.2012.Database.TransactionLogSpaceFreePercentMonitor	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.Database.DBSpaceMonitor	PerformanceHealth	False			0	True	Error	Normal	True	Microsoft.SQLServer.2012.Database.TransactionLogSpaceFreePercent.MonitorType	True	Public
	Average Wait Time	Average Wait Time monitor for 2012 DBs	Microsoft.SQLServer.2012.DBEngine.AverageWaitTimeMonitor	Microsoft.SQLServer.2012.DBEngine	System.Health.PerformanceState	PerformanceHealth	True			0	True	Warning	Normal	True	Microsoft.SQLServer.2012.DBEngine.AverageWaitTime.MonitorType	True	Public
	Blocking Sessions	Monitors blocked sessions for a SQL instance.	Microsoft.SQLServer.2012.DBEngine.BlockedSPIDsMonitor	Microsoft.SQLServer.2012.DBEngine	System.Health.PerformanceState	PerformanceHealth	False			0	True	Error	High	True	Microsoft.SQLServer.2012.DBEngine.BlockedSPIDs	True	Public
	Buffer Cache Hit Ratio	Buffer Cache Hit Ratio for 2012 DB Engine	Microsoft.SQLServer.2012.DBEngine.BufferCacheHitRatioMonitor	Microsoft.SQLServer.2012.DBEngine	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2012.DBEngine.BufferCacheHitRatio.MonitorType	True	Public
	Service Pack Compliance	Monitors the service pack level of the database engine against the compliant setting	Microsoft.SQLServer.2012.DBEngine.Configuration.ServicePackLevel	Microsoft.SQLServer.2012.DBEngine	System.Health.ConfigurationState	ConfigurationHealth	True			0	True	MatchMonitorHealth	Normal	True	Microsoft.SQLServer.2012.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.2012.DBEngine.Configuration.SPNStatusMonitor	Microsoft.SQLServer.2012.DBEngine	System.Health.ConfigurationState	AvailabilityHealth	True			0	True	Warning	Normal	True	Microsoft.SQLServer.2012.DBEngine.Configuration.SPNStatus	True	Public
	CPU Utilization (\%)	CPU Utilization (\%) for 2012 DB Engine	Microsoft.SQLServer.2012.DBEngine.CPUUsagePercentMonitor	Microsoft.SQLServer.2012.DBEngine	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2012.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.2012.DBEngine.FullTextSearchServiceMonitor	Microsoft.SQLServer.2012.DBEngine	System.Health.AvailabilityState	AvailabilityHealth	False			0	True	MatchMonitorHealth	Normal	True	Microsoft.Windows.CheckNTServiceStateMonitorType	True	Public
	Page Life Expectancy	Page Life Expectancy (s) for 2012 DB Engine	Microsoft.SQLServer.2012.DBEngine.PageLifeExpectancyMonitor	Microsoft.SQLServer.2012.DBEngine	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2012.DBEngine.PageLifeExpectancy.MonitorType	True	Public
	SQL Server Windows Service	This monitor checks the status of the SQL Database Engine service.	Microsoft.SQLServer.2012.DBEngine.ServiceMonitor	Microsoft.SQLServer.2012.DBEngine	System.Health.AvailabilityState	AvailabilityHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2012.CheckWinServiceStateMonitorType	True	Public
	SQL Re-Compilation	SQL Re-Compilation for 2012 DB Engine	Microsoft.SQLServer.2012.DBEngine.SQLReCompilationMonitor	Microsoft.SQLServer.2012.DBEngine	System.Health.PerformanceState	PerformanceHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2012.DBEngine.SQLReCompilation.MonitorType	True	Public
	Stolen Server Memory	Stolen Server Memory for 2012 DB Engine	Microsoft.SQLServer.2012.DBEngine.StolenServerMemoryMonitor	Microsoft.SQLServer.2012.DBEngine	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2012.DBEngine.StolenServerMemory.MonitorType	True	Public
	Thread Count	Thread Count for 2012 DB Engine	Microsoft.SQLServer.2012.DBEngine.ThreadCountMonitor	Microsoft.SQLServer.2012.DBEngine	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2012.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.2012.DBEngine.UserConnectionsBaselineMonitor	Microsoft.SQLServer.2012.DBEngine	System.Health.PerformanceState	PerformanceHealth	False			0	True	MatchMonitorHealth	Normal	True	System.Performance.TwoStateAboveBaseliningMonitorWithoutCompression	True	Public
	Database Health 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.	Microsoft.SQLServer.2012.DBErrorUserPolicyStateMonitor	Microsoft.SQLServer.2012.DatabaseErrorUserPolicy	System.Health.AvailabilityState	AvailabilityHealth	True			0	False			True	Microsoft.SQLServer.2012.TwoStatePolicyMonitorType	True	Public
	Database Health 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.	Microsoft.SQLServer.2012.DBWarningUserPolicyStateMonitor	Microsoft.SQLServer.2012.DatabaseWarningUserPolicy	System.Health.AvailabilityState	AvailabilityHealth	True			0	False			True	Microsoft.SQLServer.2012.TwoStatePolicyMonitorType	True	Public
	SQL Server Integration Services Windows Service	This monitor checks the status of the SQL Integration Services service.	Microsoft.SQLServer.2012.IntegrationServices.ServiceMonitor	Microsoft.SQLServer.2012.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.2012.Monitoring.DBFileSpaceMonitor	Microsoft.SQLServer.2012.DBFile	System.Health.PerformanceState	PerformanceHealth	True			0	False			True	Microsoft.SQLServer.2012.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.2012.Monitoring.DBLogFileSpaceMonitor	Microsoft.SQLServer.2012.DBLogFile	System.Health.PerformanceState	PerformanceHealth	True			0	False			True	Microsoft.SQLServer.2012.DBLogFileSizeMonitorType	True	Public
	SQL Server Reporting Services Windows Service	This monitor checks the status of the SQL Reporting Services service.	Microsoft.SQLServer.2012.ReportingServices.ServiceMonitor	Microsoft.SQLServer.2012.ReportingServices	System.Health.AvailabilityState	AvailabilityHealth	True			0	True	Error	Normal	True	Microsoft.Windows.CheckNTServiceStateMonitorType	True	Public