All Dependency Monitors in Microsoft.SQLServer.2016.AlwaysOn.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
	Availability Replicas Connection (rollup)	This monitor rolls up the connection state of all availability replicas and check whether any availability replica is DISCONNECTED. The monitor is unhealthy when any availability replica is DISCONNECTED. The monitor is healthy otherwise. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2016.AlwaysOn.AllAvailabilityReplicasAreConnectedRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	System.Health.AvailabilityState	WorstOf		Microsoft.SQLServer.2016.AlwaysOn.AllAvailabilityReplicasAreConnected	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	False			True	True	Public
	Availability Group Automatic Failover (rollup)	This monitor checks if the availability group has at least one secondary replica which is failover ready. The monitor becomes unhealthy and alert is registered when the failover mode of primary replica is automatic but none of secondary replica in the availability group is automatic failover ready. The monitor is healthy when at least one secondary replica is automatic failover ready. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2016.AlwaysOn.AutomaticFailoverReadinessRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	System.Health.AvailabilityState	WorstOf		Microsoft.SQLServer.2016.AlwaysOn.AutomaticFailoverReadiness	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	True	Error	Normal	True	True	Public
	Availability Group Critical Policies (rollup)	This monitor is the rollup monitor for all Custom User Policies which have Availability Group as Facet and one of the predefined error categories as Policy Category.	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthErrorUserPolicyStateMonitorRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthUserPolicyAggregateMonitor	WorstOf		Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupErrorPolicyStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthHostsErrorUserPolicy	AvailabilityHealth	True	False			True	True	Public
	Availability Group Warning Policies (rollup)	This monitor is the rollup monitor for all Custom User Policies which have Availability Group as Facet and one of the predefined warning categories as Policy Category.	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthWarningUserPolicyStateMonitorRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthUserPolicyAggregateMonitor	WorstOf		Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupWarningPolicyStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthHostsWarningUserPolicy	AvailabilityHealth	True	False			True	True	Public
	Availability Group Online (rollup)	This monitor checks the online or offline state of availability group. The monitor is in unhealthy state and alert is raised when the availability group’s cluster resource is offline or the availability group does not have a primary replica. The monitor state is healthy when the cluster resource of availability group is online and the availability group has a primary replica. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupOnlineRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	System.Health.AvailabilityState	WorstOf		Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupOnline	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	True	Error	Normal	True	True	Public
	Availability Group Extended Health State (rollup)	This is the rollup monitor for all extended health monitors. Extended health monitors are automatically generated by discovering the existing health policies in SQL server instances.	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupUserPolicyStateMonitorRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	System.Health.AvailabilityState	WorstOf		Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthUserPolicyAggregateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	False			True	True	Public
	Availability Replica Critical Policies (rollup)	This monitor is the rollup monitor for all Custom User Policies which have Availability Replica as Facet and one of the predefined error categories as Policy Category.	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaErrorUserPolicyStateMonitorRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaUserPolicyAggregateMonitor	WorstOf		Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaErrorPolicyStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaHostsErrorUserPolicy	AvailabilityHealth	True	False			True	True	Public
	Availability Replicas Role (rollup)	This monitor rolls up the state of role of all availability replicas and checks whether any availability replica is not in a healthy role. The monitor is unhealthy when any availability replica is neither primary nor secondary. The monitor is healthy state otherwise. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaRoleStateRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	System.Health.AvailabilityState	WorstOf		Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaRoleState	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	False			True	True	Public
	Synchronous Replicas Data Synchronization (rollup)	This monitor rolls up the data synchronization state of all availability replicas and checks whether any availability replica is not in the expected synchronization state. The monitor is unhealthy when any asynchronous replica is not in SYNCHRONIZING state and any synchronous replica is not in SYNCHRONIZED state. The monitor state is healthy otherwise. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasSynchronizationStateRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	System.Health.AvailabilityState	WorstOf		Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasSynchronizationState	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	False			True	True	Public
	Availability Replicas Data Synchronization (rollup)	This monitor rolls up the data synchronization state of all availability replicas in the availability group and check whether any availability replica’s synchronization is not operational. The monitor is unhealthy if any of availability replica’s data synchronization state is NOT SYNCHRONIZING. The monitor is healthy when none of availability replica’s data synchronization state is NOT SYNCHRONIZING. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasSynchronizingRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	System.Health.AvailabilityState	WorstOf		Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasSynchronizing	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	False			True	True	Public
	Availability Replica Warning Policies (rollup)	This monitor is the rollup monitor for all Custom User Policies which have Availability Replica as Facet and one of the predefined warning categories as Policy Category.	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaWarningUserPolicyStateMonitorRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaUserPolicyAggregateMonitor	WorstOf		Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaWarningPolicyStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaHostsWarningUserPolicy	AvailabilityHealth	True	False			True	True	Public
	WSFC Cluster (rollup)	This monitor checks the state of Windows Server Failover Cluster (WSFC) service. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.2016.AlwaysOn.ClusterStateMonitorRollup	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	System.Health.AvailabilityState	WorstOf		Microsoft.SQLServer.2016.AlwaysOn.ClusterStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	AvailabilityHealth	True	True	Error	Normal	True	True	Public
	Database Replica Critical Policies (rollup)	This monitor is the rollup monitor for all Custom User Policies which have Database Replica State as Facet and one of the predefined error categories as Policy Category.	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaErrorUserPolicyStateMonitorRollup	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaUserPolicyAggregateMonitor	WorstOf		Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaErrorPolicyStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaHostsErrorUserPolicy	AvailabilityHealth	True	False			True	True	Public
	Database Replica Warning Policies (rollup)	This monitor is the rollup monitor for all Custom User Policies which have Database Replica State as Facet and one of the predefined warning categories as Policy Category.	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaWarningUserPolicyStateMonitorRollup	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaUserPolicyAggregateMonitor	WorstOf		Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaWarningPolicyStateMonitor	Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaHostsWarningUserPolicy	AvailabilityHealth	True	False			True	True	Public
	Availability Database Backup Status (rollup)	This monitor is a dependency (rollup) monitor. The monitor checks availability of a full database backup and its age as reported by Microsoft SQL Server; it does not apply any logic regarding the replicas preferred for the backup.	Microsoft.SQLServer.2016.AlwaysOn.Rollup.AvailabilityDatabase.BackupStatus	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityDatabase	System.Health.AvailabilityState	BestOf		Microsoft.SQLServer.2016.AlwaysOn.Monitor.AvailabilityDatabaseHealth.BackupStatus	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityDatabaseReferencesAvailabilityDatabaseHealth	AvailabilityHealth	True	True	Error	Normal	True	True	Public
	Availability Databases Availability	Rolls up all Availability Databases availability monitors to the Availability Group.	Microsoft.SQLServer.2016.AlwaysOn.Rollup.AvailabilityGroup.AvailabilityDBToAvailabilityGroupAvailability	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	System.Health.AvailabilityState	WorstOf		System.Health.AvailabilityState	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHostsAvailabilityDatabase	AvailabilityHealth	True	False			True	True	Public
	Availability Databases Configuration	Rolls up all Availability Databases configuration monitors to the Availability Group.	Microsoft.SQLServer.2016.AlwaysOn.Rollup.AvailabilityGroup.AvailabilityDBToAvailabilityGroupConfiguration	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	System.Health.ConfigurationState	WorstOf		System.Health.ConfigurationState	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHostsAvailabilityDatabase	ConfigurationHealth	True	False			True	True	Public
	Availability Databases Performance	Rolls up all Availability Databases performance monitors to the Availability Group.	Microsoft.SQLServer.2016.AlwaysOn.Rollup.AvailabilityGroup.AvailabilityDBToAvailabilityGroupPerformance	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	System.Health.PerformanceState	WorstOf		System.Health.PerformanceState	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHostsAvailabilityDatabase	PerformanceHealth	True	False			True	True	Public
	Availability Databases Security	Rolls up all Availability Databases security monitors to the Availability Group.	Microsoft.SQLServer.2016.AlwaysOn.Rollup.AvailabilityGroup.AvailabilityDBToAvailabilityGroupSecurity	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroup	System.Health.SecurityState	WorstOf		System.Health.SecurityState	Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHostsAvailabilityDatabase	SecurityHealth	True	False			True	True	Public