All Dependency Monitors in Microsoft.SQLServer.2014.Monitoring Management Pack

	DisplayName	Description	ID	Target	Parent Monitor	Algorithm	Algorithm Parameter	Source Monitor	Relationship	Category	Enabled	Alert Generate	Alert Severity	Alert Priority	Alert Auto Resolve	Remotable	Accessibility
	Agent job availability (rollup)	This monitor rolls up the availability state from SQL Agent Jobs to SQL Agent.	Microsoft.SQLServer.2014.Agent.AgentJobAvailabilityRollup	Microsoft.SQLServer.2014.Agent	System.Health.AvailabilityState	WorstOf		System.Health.AvailabilityState	Microsoft.SQLServer.2014.AgentHostsAgentJob	AvailabilityHealth	True	False			True	True	Public
	Agent job performance (rollup)	This monitor rolls up the performance state from SQL Agent Jobs to SQL Agent.	Microsoft.SQLServer.2014.Agent.AgentJobPerformanceRollup	Microsoft.SQLServer.2014.Agent	System.Health.PerformanceState	WorstOf		System.Health.PerformanceState	Microsoft.SQLServer.2014.AgentHostsAgentJob	PerformanceHealth	True	False			True	True	Public
	DB File Group Space (rollup)	This dependency monitor rolls up the overall space health from Database File Groups to the Database.	Microsoft.SQLServer.2014.Database.DBFileGroupPerfRollup	Microsoft.SQLServer.2014.Database	Microsoft.SQLServer.2014.Database.DBSpaceMonitor	WorstOf		Microsoft.SQLServer.2014.Database.DBFileGroupSpaceMonitor	Microsoft.SQLServer.2014.DBHostsFileGroup	PerformanceCollection	True	False			True	True	Public
	DB Log File Space (rollup)	The monitor oversees the space available in all transaction log files in the database and on related media. The space available on the media hosting transaction log files is only included as part of the available space if auto grow is enabled for at least one transaction log file. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2014.Database.DBLogFileSpaceMonitorRollUp	Microsoft.SQLServer.2014.Database	Microsoft.SQLServer.2014.Database.DBLogFileSpaceMonitor	BestOf		Microsoft.SQLServer.2014.Monitoring.DBLogFileSpaceMonitor	Microsoft.SQLServer.2014.DBHostsLogFile	PerformanceHealth	True	True	MatchMonitorHealth	Normal	True	True	Public
	Database Critical Policies (rollup)	This is the rollup monitor for all extended health monitors. Extended health monitors are automatically generated by discovering existing health policies in SQL server instances. This monitor is for critical custom user policies.	Microsoft.SQLServer.2014.DatabaseErrorUserPolicyStateMonitorRollup	Microsoft.SQLServer.2014.Database	Microsoft.SQLServer.2014.DatabaseUserPolicyAggregateMonitor	WorstOf		Microsoft.SQLServer.2014.DBErrorUserPolicyStateMonitor	Microsoft.SQLServer.2014.DatabaseHostsDBErrorUserPolicy	AvailabilityHealth	True	False			True	True	Public
	Database Warning Policies (rollup)	This is the rollup monitor for all extended health monitors. Extended health monitors are automatically generated by discovering existing health policies in SQL server instances. This monitor is for warning custom user policies.	Microsoft.SQLServer.2014.DatabaseWarningUserPolicyStateMonitorRollup	Microsoft.SQLServer.2014.Database	Microsoft.SQLServer.2014.DatabaseUserPolicyAggregateMonitor	WorstOf		Microsoft.SQLServer.2014.DBWarningUserPolicyStateMonitor	Microsoft.SQLServer.2014.DatabaseHostsDBWarningUserPolicy	AvailabilityHealth	True	False			True	True	Public
	Database Performance (rollup)	This monitor rolls up the performance state from Database to DB Engine.	Microsoft.SQLServer.2014.DBEngine.DBPerformanceRollup	Microsoft.SQLServer.2014.DBEngine	System.Health.PerformanceState	WorstOf		System.Health.PerformanceState	Microsoft.SQLServer.2014.DBEngineHostsDatabase	PerformanceCollection	True	False			True	True	Public
	DB File Space (rollup)	The monitor oversees the space available in all file groups in the database and on related media. The space available on the media hosting files is only included as part of the available space if auto grow is enabled for at least one file. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2014.DBFileGroup.DBFileSpaceMonitorRollUp	Microsoft.SQLServer.2014.DBFileGroup	Microsoft.SQLServer.2014.Database.DBFileGroupSpaceMonitor	BestOf		Microsoft.SQLServer.2014.Monitoring.DBFileSpaceMonitor	Microsoft.SQLServer.2014.DBFileGroupHostsDBFile	PerformanceHealth	True	True	MatchMonitorHealth	Normal	True	True	Public
	SQL Server 2014 In-Memory OLTP Number of files (rollup)	The monitor reports a Critical state when the number of Active Checkpoint File Pairs in In-Memory file group in the database is higher than the specified threshold. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2014.DependencyMonitor.Database.ActivePairs	Microsoft.SQLServer.2014.Database	System.Health.PerformanceState	WorstOf		Microsoft.SQLServer.2014.Monitor.DBFileGroupFx.ActivePairs	Microsoft.SQLServer.2014.RelationshipType.DBHostsDBFileGroupFx	PerformanceCollection	True	False			False	True	Public
	DB Memory Optimized Data File Group Space (rollup)	This dependency monitor rolls up the overall health from Memory Optimized Data File Group to Database.	Microsoft.SQLServer.2014.DependencyMonitor.Database.DBFileGroupFxPerfRollup	Microsoft.SQLServer.2014.Database	Microsoft.SQLServer.2014.Database.DBSpaceMonitor	WorstOf		Microsoft.SQLServer.2014.AggregateMonitor.DBFileGroupFx.SpaceMonitor	Microsoft.SQLServer.2014.RelationshipType.DBHostsDBFileGroupFx	PerformanceCollection	True	False			True	True	Public
	Garbage Collection State (rollup)	The monitor reports a Critical State and raises an alert if the amount of space used by active rows in all In-Memory data files drops below the Threshold setting, expressed as a percentage of the size of data files. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2014.DependencyMonitor.Database.GarbageCollectionState	Microsoft.SQLServer.2014.Database	System.Health.PerformanceState	WorstOf		Microsoft.SQLServer.2014.Monitor.DBFileGroupFx.GarbageCollectionState	Microsoft.SQLServer.2014.RelationshipType.DBHostsDBFileGroupFx	PerformanceCollection	True	False			True	True	Public
	Resources Pool Memory Consumption (rollup)	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. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2014.DependencyMonitor.Database.MemoryConsumptionRollUp	Microsoft.SQLServer.2014.Database	System.Health.PerformanceState	WorstOf		Microsoft.SQLServer.2014.Monitor.UserResourcePool.MemoryConsumption	Microsoft.SQLServer.2014.RelationshipType.DatabaseReferencesUserResourcePool	PerformanceCollection	True	False			False	True	Public
	DB Memory Optimized Data File Group Container Space (rollup)	The monitor reports a warning when the available disk space for all In-Memory OLTP File Group Containers 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 state when the available space drops below the Critical Threshold. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2014.DependencyMonitor.DBFileGroupFx.ContainerFreeSpacePercentRollUp	Microsoft.SQLServer.2014.DBFileGroupFx	Microsoft.SQLServer.2014.AggregateMonitor.DBFileGroupFx.SpaceMonitor	BestOf		Microsoft.SQLServer.2014.Monitor.Container.FreeSpacePercent	Microsoft.SQLServer.2014.DBFileGroupFxHostsContainer	PerformanceHealth	True	True	MatchMonitorHealth	Normal	True	True	Public