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. Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express; there is no appropriate discovered object. This monitor is disabled by default. Please use overrides to enable it when necessary.	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. Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express.	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. Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express; there is no appropriate discovered object.	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. Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express; there is no appropriate discovered object.	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. Note that SQL Analysis Services service is not supported by any edition of SQL Server Express.	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™. Note that the monitor ignores Always On databases. Therefore, it is always "green" for those databases. For backups of Always On databases, use the dedicated monitors at the Availability Group.	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 free 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. Note that this monitor does not count free space for FILESTREAM Filegroups.	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. Note that all Log Shipping is not supported by any edition of SQL Server Express.	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. Note that all Log Shipping is not supported by any edition of SQL Server Express.	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 an 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. Note that the monitor is always in "Healthy" state for non-domain joined machines.	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 Full-text Filter Daemon Launcher Service	This monitor checks the status of the SQL Full-text Filter Daemon Launcher service. Note that SQL Full-text Search feature is not available in any edition of SQL Server Express, except SQL Server Express with Advanced Services. This monitor is disabled by default. Please use overrides to enable it when necessary.	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. Note that all SQL Express editions support only SQL Server Import and Export Wizard, along with Built-in data source connectors. There is no appropriate discovered object (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 FILESTREAM Filegroup Free Space	The monitor reports a warning when the free space drops below the Warning Threshold setting, expressed as percentage of the sum of data size. The monitor reports a critical alert when the free space drops below the Critical Threshold.	Microsoft.SQLServer.2012.Monitoring.DBFileStreamGroupSpaceMonitor	Microsoft.SQLServer.2012.DBFileGroupFd	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2012.DBFileStreamGroupSizeMonitorType	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. Note that SQL Server Reporting Services Windows service is not supported by any edition of SQL Server Express, except SQL Server Express with Advanced Services.	Microsoft.SQLServer.2012.ReportingServices.ServiceMonitor	Microsoft.SQLServer.2012.ReportingServices	System.Health.AvailabilityState	AvailabilityHealth	True			0	True	Error	Normal	True	Microsoft.Windows.CheckNTServiceStateMonitorType	True	Public