| 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 | | | False | 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 | | | False | 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 | | | False | 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 | | | False | 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 | | | False | 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 | | | False | 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 | | | False | True | Public |