All Aggregate Monitors in Microsoft.SQLServer.Core.Library Management Pack

	DisplayName	Description	ID	Target	Parent Monitor	Algorithm	Category	Enabled	Alert Generate	Alert Severity	Alert Priority	Alert Auto Resolve	Remotable	Accessibility
	Availability Database Backup Status (rollup)	The monitor checks availability of a full database backup and its age as reported by Microsoft SQL Server. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.Core.Rollup.AvailabilityDatabase.BackupStatusAggregate	Microsoft.SQLServer.Core.AvailabilityDatabase	System.Health.AvailabilityState	BestOf	AvailabilityHealth	True	True	Error	Normal	True	True	Public
	Availability Database Log Backup Status (rollup)	The monitor checks availability of a database log backup and its age as reported by Microsoft SQL Server. This monitor is a dependency (rollup) monitor.	Microsoft.SQLServer.Core.Rollup.AvailabilityDatabase.DBLogBackupStatusAggregate	Microsoft.SQLServer.Core.AvailabilityDatabase	System.Health.AvailabilityState	BestOf	AvailabilityHealth	True	True	Error	Normal	True	True	Public
	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 an aggregate (rollup) monitor.	Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AllAvailabilityReplicasAreConnected	Microsoft.SQLServer.Core.AvailabilityGroup	System.Health.AvailabilityState	BestOf	AvailabilityHealth	True	True	Warning	Normal	True	True	Public
	Availability Group Automatic Failover (rollup)	This monitor checks whether 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 an aggregate (rollup) monitor.	Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AutomaticFailoverReadiness	Microsoft.SQLServer.Core.AvailabilityGroup	System.Health.AvailabilityState	BestOf	AvailabilityHealth	True	True	Error	Normal	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 an aggregate (rollup) monitor.	Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityGroupOnline	Microsoft.SQLServer.Core.AvailabilityGroup	System.Health.AvailabilityState	WorstOf	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 on SQL Server instances.	Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityGroupUserPolicyState	Microsoft.SQLServer.Core.AvailabilityGroup	System.Health.AvailabilityState	WorstOf	AvailabilityHealth	True	False			True	True	Public
	Availability Replica Role (rollup)	This monitor rolls up the state of role of all Availability Replica's 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 an aggregate (rollup) monitor.	Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityReplicaRoleState	Microsoft.SQLServer.Core.AvailabilityGroup	System.Health.AvailabilityState	BestOf	AvailabilityHealth	True	True	Warning	Normal	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 an aggregate (rollup) monitor.	Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityReplicasSynchronizationState	Microsoft.SQLServer.Core.AvailabilityGroup	System.Health.AvailabilityState	BestOf	AvailabilityHealth	True	True	Warning	Normal	True	True	Public
	Availability Replica 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 an aggregate (rollup) monitor.	Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityReplicasSynchronizing	Microsoft.SQLServer.Core.AvailabilityGroup	System.Health.AvailabilityState	WorstOf	AvailabilityHealth	True	True	Warning	Normal	True	True	Public