All Dependency Monitors in Microsoft.SQLServer.2016.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. 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.2016.Agent.AgentJobAvailabilityRollup	Microsoft.SQLServer.2016.Agent	System.Health.AvailabilityState	WorstOf		System.Health.AvailabilityState	Microsoft.SQLServer.2016.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. 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.2016.Agent.AgentJobPerformanceRollup	Microsoft.SQLServer.2016.Agent	System.Health.PerformanceState	WorstOf		System.Health.PerformanceState	Microsoft.SQLServer.2016.AgentHostsAgentJob	PerformanceHealth	True	False			True	True	Public
	DB Filegroup Space (rollup)	This dependency monitor rolls up the overall space health from Database Filegroups to the Database.	Microsoft.SQLServer.2016.Database.DBFileGroupPerfRollup	Microsoft.SQLServer.2016.Database	Microsoft.SQLServer.2016.Database.DBSpaceMonitor	WorstOf		Microsoft.SQLServer.2016.Database.DBFileGroupSpaceMonitor	Microsoft.SQLServer.2016.DBHostsFileGroup	PerformanceCollection	True	False			True	True	Public
	DB FILESTREAM Filegroup Space (rollup)	This dependency monitor rolls up the overall space health from Database FILESTREAM Filegroups to the Database.	Microsoft.SQLServer.2016.Database.DBFileStreamFileGroupPerfRollup	Microsoft.SQLServer.2016.Database	Microsoft.SQLServer.2016.Database.DBSpaceMonitor	WorstOf		Microsoft.SQLServer.2016.Monitoring.DBFileStreamGroupSpaceMonitor	Microsoft.SQLServer.2016.RelationshipType.DBHostsDBFileGroupFd	PerformanceCollection	True	False			False	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 free space if autogrowth is enabled for at least one transaction log file. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2016.Database.DBLogFileSpaceMonitorRollUp	Microsoft.SQLServer.2016.Database	Microsoft.SQLServer.2016.Database.DBLogFileSpaceMonitor	BestOf		Microsoft.SQLServer.2016.Monitoring.DBLogFileSpaceMonitor	Microsoft.SQLServer.2016.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.2016.DatabaseErrorUserPolicyStateMonitorRollup	Microsoft.SQLServer.2016.Database	Microsoft.SQLServer.2016.DatabaseUserPolicyAggregateMonitor	WorstOf		Microsoft.SQLServer.2016.DBErrorUserPolicyStateMonitor	Microsoft.SQLServer.2016.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.2016.DatabaseWarningUserPolicyStateMonitorRollup	Microsoft.SQLServer.2016.Database	Microsoft.SQLServer.2016.DatabaseUserPolicyAggregateMonitor	WorstOf		Microsoft.SQLServer.2016.DBWarningUserPolicyStateMonitor	Microsoft.SQLServer.2016.DatabaseHostsDBWarningUserPolicy	AvailabilityHealth	True	False			True	True	Public
	Database Performance (rollup)	This monitor rolls up the performance state from Database to DB Engine.	Microsoft.SQLServer.2016.DBEngine.DBPerformanceRollup	Microsoft.SQLServer.2016.DBEngine	System.Health.PerformanceState	WorstOf		System.Health.PerformanceState	Microsoft.SQLServer.2016.DBEngineHostsDatabase	PerformanceCollection	True	False			True	True	Public
	DB File Space (rollup)	The monitor oversees the space available in all Filegroups in the database and on related media. The space available on the media hosting files is only included as part of the free space if autogrowth is enabled for at least one file. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2016.DBFileGroup.DBFileSpaceMonitorRollUp	Microsoft.SQLServer.2016.DBFileGroup	Microsoft.SQLServer.2016.Database.DBFileGroupSpaceMonitor	BestOf		Microsoft.SQLServer.2016.Monitoring.DBFileSpaceMonitor	Microsoft.SQLServer.2016.DBFileGroupHostsDBFile	PerformanceHealth	True	True	MatchMonitorHealth	Normal	True	True	Public
	DB Memory-Optimized Data Filegroup Space (rollup)	This dependency monitor rolls up the overall health from Memory-Optimized Data Filegroup to Database.	Microsoft.SQLServer.2016.DependencyMonitor.Database.DBFileGroupFxPerfRollup	Microsoft.SQLServer.2016.Database	Microsoft.SQLServer.2016.Database.DBSpaceMonitor	WorstOf		Microsoft.SQLServer.2016.AggregateMonitor.DBFileGroupFx.SpaceMonitor	Microsoft.SQLServer.2016.RelationshipType.DBHostsDBFileGroupFx	PerformanceCollection	True	False			True	True	Public
	[Deprecated] 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 Memory-Optimized Data files drops below the Threshold setting, expressed as a percentage of the size of data files. This monitor is a dependency (rollup) monitor. This monitor is considered to be obsolete in this Management Pack.	Microsoft.SQLServer.2016.DependencyMonitor.Database.GarbageCollectionState	Microsoft.SQLServer.2016.Database	System.Health.PerformanceState	WorstOf		Microsoft.SQLServer.2016.Monitor.DBFileGroupFx.GarbageCollectionState	Microsoft.SQLServer.2016.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 Memory-Optimized Data tables for the given resource pool. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2016.DependencyMonitor.Database.MemoryConsumptionRollUp	Microsoft.SQLServer.2016.Database	System.Health.PerformanceState	WorstOf		Microsoft.SQLServer.2016.Monitor.UserResourcePool.MemoryConsumption	Microsoft.SQLServer.2016.RelationshipType.DatabaseReferencesUserResourcePool	PerformanceCollection	True	False			False	True	Public
	Memory-Optimized Data Stale Checkpoint File Pairs Ratio (rollup)	The monitor reports a warning state and raises an alert when the ratio of stale checkpoint file pairs in Memory-Optimized Data Filegroup is higher than the specified thresholds. This monitor is a dependency (rollup) monitor. Please note that the alerts are raised only if the corresponding database is reasonably big (300 or more checkpoint files total).	Microsoft.SQLServer.2016.DependencyMonitor.Database.StaleCFPs	Microsoft.SQLServer.2016.Database	System.Health.PerformanceState	WorstOf		Microsoft.SQLServer.2016.Monitor.DBFileGroupFx.StaleCFPs	Microsoft.SQLServer.2016.RelationshipType.DBHostsDBFileGroupFx	PerformanceCollection	True	False			False	True	Public
	DB Memory-Optimized Data Filegroup Container Space (rollup)	The monitor reports a warning when the available disk space for all Memory-Optimized Data Filegroup Containers drops below the Warning Threshold setting, expressed as percentage of the sum of the Memory-Optimized Data Filegroup Container size plus disk free space. The monitor reports a critical state when the free space drops below the Critical Threshold. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2016.DependencyMonitor.DBFileGroupFx.ContainerFreeSpacePercentRollUp	Microsoft.SQLServer.2016.DBFileGroupFx	Microsoft.SQLServer.2016.AggregateMonitor.DBFileGroupFx.SpaceMonitor	BestOf		Microsoft.SQLServer.2016.Monitor.Container.FreeSpacePercent	Microsoft.SQLServer.2016.DBFileGroupFxHostsContainer	PerformanceHealth	True	True	MatchMonitorHealth	Normal	True	True	Public
	Average length of the row chains in the hash buckets (rollup)	This monitor checks Hash Index Empty Buckets Count and Average Length of the Row Chains in the SQL Database. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2016.DependencyMonitor.HashIndexAvgChainLengthMonitor	Microsoft.SQLServer.2016.Database	System.Health.ConfigurationState	WorstOf		Microsoft.SQLServer.2016.Monitoring.HashIndexAvgChainLengthMonitor	Microsoft.SQLServer.2016.RelationshipType.DBHostsDBFileGroupFx	ConfigurationHealth	True	False			False	True	Public
	Empty Bucket percent in the hash index (rollup)	This monitor checks Hash Index Empty Buckets Count in the SQL Database. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2016.DependencyMonitor.HashIndexEmptyBucketsCountMonitor	Microsoft.SQLServer.2016.Database	System.Health.ConfigurationState	WorstOf		Microsoft.SQLServer.2016.Monitoring.HashIndexEmptyBucketsCountMonitor	Microsoft.SQLServer.2016.RelationshipType.DBHostsDBFileGroupFx	ConfigurationHealth	True	False			False	True	Public
	XTP Configuration (rollup)	This monitor checks the status of the SQL Database XTP Configuration. This monitor is a dependency (rollup) monitor. Note that this monitor works only with Enterprise, Developer, and Evaluation editions of Microsoft SQL Server. With other editions, the monitor will always be in warning state.	Microsoft.SQLServer.2016.DependencyMonitor.XTPConfigurationMonitor	Microsoft.SQLServer.2016.Database	System.Health.ConfigurationState	WorstOf		Microsoft.SQLServer.2016.Monitoring.XTPConfigurationMonitor	Microsoft.SQLServer.2016.RelationshipType.DBHostsDBFileGroupFx	ConfigurationHealth	True	False			True	True	Public