All Unit Monitors in Microsoft.SQLServer.2014.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: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.Agent.LongRunningJobs	Microsoft.SQLServer.2014.Agent	System.Health.PerformanceState	PerformanceHealth	False			0	True	MatchMonitorHealth	Normal	True	Microsoft.SQLServer.2014.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.2014.Agent.ServiceMonitor	Microsoft.SQLServer.2014.Agent	System.Health.AvailabilityState	AvailabilityHealth	True			0	True	Error	Normal	True	Microsoft.Windows.CheckNTServiceStateMonitorType	True	Public
	Job Duration	Monitors Agent Job Duration.	Microsoft.SQLServer.2014.AgentJob.JobDuration	Microsoft.SQLServer.2014.AgentJob	System.Health.PerformanceState	PerformanceCollection	True			0	False			True	Microsoft.SQLServer.2014.AgentLongRunningJobsProviderPerJob	True	Public
	Last Run Status	SQL 2014 Agent Job Last Run State Monitor. Monitors the last run state of an SQL Agent Job.	Microsoft.SQLServer.2014.AgentJob.JobLastRunState	Microsoft.SQLServer.2014.AgentJob	System.Health.AvailabilityState	AvailabilityHealth	True			0	False			True	Microsoft.SQLServer.2014.AgentJobLastRunProvider	True	Public
	Auto Close Configuration	Monitors the Auto Close setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.Database.Configuration.AutoClose	Microsoft.SQLServer.2014.Database	Microsoft.SQLServer.2014.Database.AutomaticConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2014.DBConfigurationStatus	True	Public
	Auto Create Statistics Configuration	Monitors the Auto Create Statistic setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.Database.Configuration.AutoCreateStat	Microsoft.SQLServer.2014.Database	Microsoft.SQLServer.2014.Database.AutomaticConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2014.DBConfigurationStatus	True	Public
	Auto Shrink Configuration	Monitors the Auto Shrink setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.Database.Configuration.AutoShrink	Microsoft.SQLServer.2014.Database	Microsoft.SQLServer.2014.Database.AutomaticConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2014.DBConfigurationStatus	True	Public
	Auto Update Statistics Configuration	Monitors the Auto Update Statistics setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.Database.Configuration.AutoUpdateSet	Microsoft.SQLServer.2014.Database	Microsoft.SQLServer.2014.Database.AutomaticConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2014.DBConfigurationStatus	True	Public
	Auto Update Statistics Async Configuration	Monitors the Auto Update Atatistics Asynchronously setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.Database.Configuration.AutoUpdateStatAsync	Microsoft.SQLServer.2014.Database	Microsoft.SQLServer.2014.Database.AutomaticConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2014.DBConfigurationStatus	True	Public
	DB Chaining Configuration	Monitors the Cross-database Ownership Chaining Enabled setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.Database.Configuration.DBChaining	Microsoft.SQLServer.2014.Database	Microsoft.SQLServer.2014.Database.ExternalAccessConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2014.DBConfigurationStatus	True	Public
	Recovery Model Configuration	Monitors the Recovery model setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.Database.Configuration.RecoveryModel	Microsoft.SQLServer.2014.Database	Microsoft.SQLServer.2014.Database.RecoveryConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2014.DBConfigurationStatus	True	Public
	Page Verify Configuration	Monitors the Page Verify setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.Database.Configuration.TornPageDetection	Microsoft.SQLServer.2014.Database	Microsoft.SQLServer.2014.Database.RecoveryConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2014.DBConfigurationStatus	True	Public
	Trustworthy Configuration	Monitors the Trustworthy setting for the database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.Database.Configuration.TrustWorthy	Microsoft.SQLServer.2014.Database	Microsoft.SQLServer.2014.Database.ExternalAccessConfiguration	ConfigurationHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2014.DBConfigurationStatus	True	Public
	Database Backup Status	This monitor checks the status of the database backup as reported by Microsoft SQL Server. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.Database.DBBackupStatusMonitor	Microsoft.SQLServer.2014.Database	System.Health.AvailabilityState	AvailabilityHealth	False			0	True	Error	Normal	True	Microsoft.SQLServer.2014.DBBackupStatus	True	Public
	DB Space Percentage Change	Monitors for a significant change of database available space over a number of sample periods. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.Database.DBSizePercentageChangeMonitor	Microsoft.SQLServer.2014.Database	Microsoft.SQLServer.2014.Database.DBSpaceMonitor	PerformanceHealth	False			0	True	MatchMonitorHealth	Normal	True	Microsoft.SQLServer.2014.DBPercentageChange	True	Public
	DB Available Space Left	Monitors the space available in the database and on the media hosting the database in percentage terms. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.Database.DBSizePercentMonitor	Microsoft.SQLServer.2014.Database	Microsoft.SQLServer.2014.Database.DBSpaceMonitor	PerformanceHealth	False			0	True	MatchMonitorHealth	High	True	Microsoft.SQLServer.2014.DBAndLogSizeMonitorType	True	Public
	Database Status	This monitor checks the status of the database as reported by Microsoft SQL Server.	Microsoft.SQLServer.2014.Database.DBStatusMonitor	Microsoft.SQLServer.2014.Database	System.Health.AvailabilityState	AvailabilityHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2014.DBStatus	True	Public
	Disk Read Latency	Disk Read Latency monitor for 2014 DBs. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.Database.DiskReadLatencyMonitor	Microsoft.SQLServer.2014.Database	System.Health.PerformanceState	PerformanceHealth	False			0	True	Error	Normal	True	Microsoft.SQLServer.2014.Database.DiskReadLatency.MonitorType	True	Public
	Disk Write Latency	Disk Write Latency monitor for 2014 DBs. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.Database.DiskWriteLatencyMonitor	Microsoft.SQLServer.2014.Database	System.Health.PerformanceState	PerformanceHealth	False			0	True	Error	Normal	True	Microsoft.SQLServer.2014.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.2014.Database.LogShippingDestinationMonitor	Microsoft.SQLServer.2014.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.2014.Database.LogShippingSourceMonitor	Microsoft.SQLServer.2014.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.2014.Database.ServiceMonitor	Microsoft.SQLServer.2014.Database	System.Health.AvailabilityState	AvailabilityHealth	True			0	False			True	Microsoft.SQLServer.2014.CheckDBEngineServiceStateMonitorType	True	Public
	Transaction Log Free Space (\%)	Transaction Log Free Space (\%) monitor for 2014 DBs. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.Database.TransactionLogSpaceFreePercentMonitor	Microsoft.SQLServer.2014.Database	Microsoft.SQLServer.2014.Database.DBSpaceMonitor	PerformanceHealth	False			0	True	Error	Normal	True	Microsoft.SQLServer.2014.Database.TransactionLogSpaceFreePercent.MonitorType	True	Public
	Average Wait Time	Average Wait Time monitor for 2014 DBs	Microsoft.SQLServer.2014.DBEngine.AverageWaitTimeMonitor	Microsoft.SQLServer.2014.DBEngine	System.Health.PerformanceState	PerformanceHealth	True			0	True	Warning	Normal	True	Microsoft.SQLServer.2014.DBEngine.AverageWaitTime.MonitorType	True	Public
	Blocking Sessions	Monitors blocked sessions for a SQL instance. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.DBEngine.BlockedSPIDsMonitor	Microsoft.SQLServer.2014.DBEngine	System.Health.PerformanceState	PerformanceHealth	False			0	True	Error	High	True	Microsoft.SQLServer.2014.DBEngine.BlockedSPIDs	True	Public
	Buffer Cache Hit Ratio	Buffer Cache Hit Ratio for 2014 DB Engine	Microsoft.SQLServer.2014.DBEngine.BufferCacheHitRatioMonitor	Microsoft.SQLServer.2014.DBEngine	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2014.DBEngine.BufferCacheHitRatio.MonitorType	True	Public
	Service Pack Compliance	Monitors the service pack level of the database engine against the compliant setting	Microsoft.SQLServer.2014.DBEngine.Configuration.ServicePackLevel	Microsoft.SQLServer.2014.DBEngine	System.Health.ConfigurationState	ConfigurationHealth	True			0	True	MatchMonitorHealth	Normal	True	Microsoft.SQLServer.2014.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.2014.DBEngine.Configuration.SPNStatusMonitor	Microsoft.SQLServer.2014.DBEngine	System.Health.ConfigurationState	AvailabilityHealth	True			0	True	Warning	Normal	True	Microsoft.SQLServer.2014.DBEngine.Configuration.SPNStatus	True	Public
	CPU Utilization (\%)	CPU Utilization (\%) for 2014 DB Engine	Microsoft.SQLServer.2014.DBEngine.CPUUsagePercentMonitor	Microsoft.SQLServer.2014.DBEngine	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2014.DBEngine.CPUUsagePercent.MonitorType	True	Public
	SQL Server Full Text Search Service	This monitor checks the status of the SQL Full Text Search service. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.DBEngine.FullTextSearchServiceMonitor	Microsoft.SQLServer.2014.DBEngine	System.Health.AvailabilityState	AvailabilityHealth	False			0	True	MatchMonitorHealth	Normal	True	Microsoft.Windows.CheckNTServiceStateMonitorType	True	Public
	Page Life Expectancy	Page Life Expectancy (s) for 2014 DB Engine	Microsoft.SQLServer.2014.DBEngine.PageLifeExpectancyMonitor	Microsoft.SQLServer.2014.DBEngine	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2014.DBEngine.PageLifeExpectancy.MonitorType	True	Public
	SQL Server Windows Service	This monitor checks the status of the SQL Server Database Engine service.	Microsoft.SQLServer.2014.DBEngine.ServiceMonitor	Microsoft.SQLServer.2014.DBEngine	System.Health.AvailabilityState	AvailabilityHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2014.CheckWinServiceStateMonitorType	True	Public
	SQL Re-Compilation	SQL Re-Compilation for 2014 DB Engine. Note: This monitor is disabled by default. Please use overrides to enable it when necessary.	Microsoft.SQLServer.2014.DBEngine.SQLReCompilationMonitor	Microsoft.SQLServer.2014.DBEngine	System.Health.PerformanceState	PerformanceHealth	False			0	True	Warning	Normal	True	Microsoft.SQLServer.2014.DBEngine.SQLReCompilation.MonitorType	True	Public
	Stolen Server Memory	Stolen Server Memory for 2014 DB Engine	Microsoft.SQLServer.2014.DBEngine.StolenServerMemoryMonitor	Microsoft.SQLServer.2014.DBEngine	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2014.DBEngine.StolenServerMemory.MonitorType	True	Public
	Thread Count	Thread Count for 2014 DB Engine	Microsoft.SQLServer.2014.DBEngine.ThreadCountMonitor	Microsoft.SQLServer.2014.DBEngine	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2014.DBEngine.ThreadCount.MonitorType	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.2014.DBErrorUserPolicyStateMonitor	Microsoft.SQLServer.2014.DatabaseErrorUserPolicy	System.Health.AvailabilityState	AvailabilityHealth	True			0	False			True	Microsoft.SQLServer.2014.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.2014.DBWarningUserPolicyStateMonitor	Microsoft.SQLServer.2014.DatabaseWarningUserPolicy	System.Health.AvailabilityState	AvailabilityHealth	True			0	False			True	Microsoft.SQLServer.2014.TwoStatePolicyMonitorType	True	Public
	In-Memory OLTP File Group Container Available Space	The monitor reports a warning when the available disk space for the In-Memory OLTP File Group Container drops below the Warning Threshold setting, expressed as percentage of the sum of the In-Memory OLTP File Group Container size plus disk free space. The monitor reports a critical alert when the available space drops below the Critical Threshold.	Microsoft.SQLServer.2014.Monitor.Container.FreeSpacePercent	Microsoft.SQLServer.2014.Container	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2014.MonitorType.Container.FreeSpacePercent	True	Public
	In-Memory OLTP Active File Pairs	The monitor reports a Critical state and raises an alert when the number of Active Checkpoint File Pairs in In-Memory file group is higher than the specified threshold.	Microsoft.SQLServer.2014.Monitor.DBFileGroupFx.ActivePairs	Microsoft.SQLServer.2014.DBFileGroupFx	System.Health.PerformanceState	PerformanceHealth	True			0	True	Warning	Normal	True	Microsoft.SQLServer.2014.MonitorType.DBFileGroupFx.ActiveAndNonActiveFiles	True	Public
	Garbage Collection	The monitor reports a Critical State and raises an alert if the amount of space used by active rows in In-Memory data files drops below the Threshold setting, expressed as a percentage of the size of data files.	Microsoft.SQLServer.2014.Monitor.DBFileGroupFx.GarbageCollectionState	Microsoft.SQLServer.2014.DBFileGroupFx	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2014.MonitorType.DBFileGroupFx.GarbageCollectionState	True	Public
	Resource Pool Memory Consumption	The monitor reports a critical state and raises an alert when the amount of memory used by the resource pool is greater than the Threshold setting, expressed as a percentage of memory available for In-Memory tables for the given resource pool.	Microsoft.SQLServer.2014.Monitor.UserResourcePool.MemoryConsumption	Microsoft.SQLServer.2014.UserResourcePool	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2014.MonitorType.UserResourcePool.MemoryConsumption	True	Public
	DB File Available Space Left	The monitor reports a warning when the available space (including both already allocated space and free space on the media) drops below the Warning Threshold setting, expressed as percentage of the sum of data size plus disk free space. The monitor reports a critical alert when the available space drops below the Critical Threshold.	Microsoft.SQLServer.2014.Monitoring.DBFileSpaceMonitor	Microsoft.SQLServer.2014.DBFile	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2014.DBFileSizeMonitorType	True	Public
	DB Log File Available Space Left	The monitor reports a warning when the available space (including both already allocated space and free space on the media) drops below the Warning Threshold setting, expressed as percentage of the sum of data size plus disk free space. The monitor reports a critical alert when the available space drops below the Critical Threshold.	Microsoft.SQLServer.2014.Monitoring.DBLogFileSpaceMonitor	Microsoft.SQLServer.2014.DBLogFile	System.Health.PerformanceState	PerformanceHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2014.DBLogFileSizeMonitorType	True	Public
	Managed Backup System Health Policy	The Managed Backup System Health Policy evaluates critical errors like lack of or invalid SQL Credentials, connectivity errors and reports the health of the system.	Microsoft.SQLServer.2014.UnitMonitor.DBEngine.SmartAdminSystemHealthPolicy	Microsoft.SQLServer.2014.DBEngine	System.Health.AvailabilityState	AvailabilityHealth	True			0	True	Error	Normal	True	Microsoft.SQLServer.2014.MonitorType.DBEngine.SmartAdminHealthPolicy	True	Public
	Managed Backup User Action Health Policy	The Managed Backup User Action Health Policy evaluates warnings such as corrupted backups, and such.	Microsoft.SQLServer.2014.UnitMonitor.DBEngine.SmartAdminUserActionHealthPolicy	Microsoft.SQLServer.2014.DBEngine	System.Health.AvailabilityState	AvailabilityHealth	True			0	True	Warning	Normal	True	Microsoft.SQLServer.2014.MonitorType.DBEngine.SmartAdminHealthPolicy	True	Public