| DisplayName | Description | ID | Target | Parent Monitor | Category | Enabled | Instance Name | Counter Name | Frequency | Alert Generate | Alert Severity | Alert Priority | Alert Auto Resolve | Monitor Type | Remotable | Accessibility | RunAs |
| Availability Replicas Connection monitor | Availability Replicas Connection | Microsoft.SQLServer.2016.AlwaysOn.AllAvailabilityReplicasAreConnected | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorType | True | Public | Microsoft.SQLServer.MonitoringAccount |
| Availability Group Automatic Failover monitor | Availability Group Automatic Failover | Microsoft.SQLServer.2016.AlwaysOn.AutomaticFailoverReadiness | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorType | True | Public | Microsoft.SQLServer.MonitoringAccount |
| Availability Group Health Policy | Two state monitor with 'Error' critical state used particularly for reflecting state of Custom User Policies which have Availability Group as Facet and one of the predefined error categories as Policy Category. | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupErrorPolicyStateMonitor | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupErrorUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.UserPolicyScriptMonitorType | True | Public | |
| Availability Group Online monitor | Availability Group Online | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupOnline | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorType | True | Public | Microsoft.SQLServer.MonitoringAccount |
| Availability Group Health Policy | Two state monitor with 'Warning' critical state used particularly for reflecting state of Custom User Policies which have Availability Group as Facet and one of the predefined warning categories as Policy Category. | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupWarningPolicyStateMonitor | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupWarningUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.UserPolicyScriptMonitorType | True | Public | |
| Availability Replica Data Synchronization | This monitor rolls up the data synchronization state of all database replica in the availability replica. The monitor is unhealthy when any database replica is not in the expected data synchronization state. The monitor is healthy otherwise. | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaDataSynchronizationHealth | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorType | True | Public | Microsoft.SQLServer.MonitoringAccount |
| Availability Replica Health Policy | Two state monitor with 'Error' critical state used particularly for reflecting state of Custom User Policies which have Availability Replica as Facet and one of the predefined error categories as Policy Category. | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaErrorPolicyStateMonitor | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaErrorUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.UserPolicyScriptMonitorType | True | Public | |
| Availability Replica Connection | This monitor checks the connection state between availability replicas. The monitor is unhealthy when the availability replica’s connection state is DISCONNECTED. The monitor is healthy otherwise. | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaIsConnected | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorType | True | Public | Microsoft.SQLServer.MonitoringAccount |
| Availability Replica Join State | This monitor checks the join state of availability replica. The monitor is unhealthy when the availability replica is added to the availability group but not joined properly. The monitor is healthy otherwise. | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaIsJoined | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorType | True | Public | Microsoft.SQLServer.MonitoringAccount |
| Availability Replicas Role monitor | Availability Replicas Role | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaRoleState | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorType | True | Public | Microsoft.SQLServer.MonitoringAccount |
| Synchronous Replicas Data Synchronization monitor | Synchronous Replicas Data Synchronization | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasSynchronizationState | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorType | True | Public | Microsoft.SQLServer.MonitoringAccount |
| Availability Replicas Data Synchronization monitor | Availability Replicas Data Synchronization | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasSynchronizing | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorType | True | Public | Microsoft.SQLServer.MonitoringAccount |
| Availability Replica Health Policy | Two state monitor with 'Warning' critical state used particularly for reflecting state of Custom User Policies which have Availability Replica as Facet and one of the predefined warning categories as Policy Category. | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaWarningPolicyStateMonitor | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaWarningUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.UserPolicyScriptMonitorType | True | Public | |
| WSFC Cluster monitor | This monitor checks the state of Windows Server Failover Cluster (WSFC) service. The monitor is unhealthy and alert is raised when the cluster is offline or in the forced quorum state. (All availability groups hosted within this cluster are offline or the disaster recovery action is required). Monitor state is healthy when the cluster state is in the normal quorum. | Microsoft.SQLServer.2016.AlwaysOn.ClusterStateMonitor | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorType | True | Public | Microsoft.SQLServer.MonitoringAccount |
| Database Replica Health Policy | Two state monitor with 'Error' critical state used particularly for reflecting state of Custom User Policies which have Database Replica State as Facet and one of the predefined error categories as Policy Category. | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaErrorPolicyStateMonitor | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaErrorUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.UserPolicyScriptMonitorType | True | Public | |
| Database Replica Health Policy | Two state monitor with 'Warning' critical state used particularly for reflecting state of Custom User Policies which have Database Replica State as Facet and one of the predefined warning categories as Policy Category. | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaWarningPolicyStateMonitor | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaWarningUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.UserPolicyScriptMonitorType | True | Public | |
| Availability Database Data Synchronization | This monitor checks the data synchronization state of database replica. The monitor is unhealthy when the data synchronization state is NOT SYNCHRONIZING or the state is not SYNCHRONIZED for synchronous commit database replica. | Microsoft.SQLServer.2016.AlwaysOn.DbrDataSynchronizationState | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorType | True | Public | Microsoft.SQLServer.MonitoringAccount |
| Availability Database Join State | This monitor checks the join state of database replica. The monitor is unhealthy when the database replica is not joined. The monitor is in healthy state otherwise. | Microsoft.SQLServer.2016.AlwaysOn.DbrJoinState | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorType | True | Public | Microsoft.SQLServer.MonitoringAccount |
| Availability Database Suspension State | This monitor checks the state of data movement of the database replica. The monitor is unhealthy when the data movement is suspended. The monitor is healthy otherwise. | Microsoft.SQLServer.2016.AlwaysOn.DbrSuspendState | Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorType | True | Public | Microsoft.SQLServer.MonitoringAccount |
| Availability Replica Role | This monitor checks the state of role of availability replica. The monitor is unhealthy when the availability replica’s role is not primary or secondary. The monitor is healthy otherwise. | Microsoft.SQLServer.2016.AlwaysOn.RoleOfAvailabilityReplicaIsHealthy | Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2016.AlwaysOn.SystemPolicyScriptMonitorType | True | Public | Microsoft.SQLServer.MonitoringAccount |