| 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 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.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupErrorPolicy.State | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupErrorUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.UserPolicy | True | Public | |
| Availability Replicas Connection monitor | Availability Replicas Connection | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AllAvailabilityReplicasAreConnected | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.SystemPolicy | True | Public | |
| Availability Group Automatic Failover monitor | Availability Group Automatic Failover | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AutomaticFailoverReadiness | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.SystemPolicy | True | Public | |
| Availability Group Online monitor | Availability Group Online | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AvailabilityGroupOnline | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.SystemPolicy | True | Public | |
| Availability Replicas Role monitor | Availability Replicas Role | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicaRoleState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.SystemPolicy | True | Public | |
| Synchronous Replicas Data Synchronization monitor | Synchronous Replicas Data Synchronization | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizationState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.SystemPolicy | True | Public | |
| Availability Replicas Data Synchronization monitor | Availability Replicas Data Synchronization | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizing | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealth | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.SystemPolicy | True | Public | |
| 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.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupWarningPolicy.State | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupWarningUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.UserPolicy | 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.2017.AlwaysOn.Windows.Monitor.AvailabilityReplica.DataSynchronizationHealth | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.SystemPolicy | 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.2017.AlwaysOn.Windows.Monitor.AvailabilityReplica.IsConnected | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.SystemPolicy | True | Public | |
| 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.2017.AlwaysOn.Windows.Monitor.AvailabilityReplica.IsJoined | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.SystemPolicy | True | Public | |
| 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.2017.AlwaysOn.Windows.Monitor.AvailabilityReplica.RoleIsHealthy | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.SystemPolicy | True | Public | |
| 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.2017.AlwaysOn.Windows.Monitor.AvailabilityReplicaErrorPolicy.State | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaErrorUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.UserPolicy | True | Public | |
| 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.2017.AlwaysOn.Windows.Monitor.AvailabilityReplicaWarningPolicy.State | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaWarningUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.UserPolicy | 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.2017.AlwaysOn.Windows.Monitor.DatabaseReplica.DataSynchronizationState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.SystemPolicy | True | Public | |
| 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.2017.AlwaysOn.Windows.Monitor.DatabaseReplica.JoinState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.SystemPolicy | True | Public | |
| 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.2017.AlwaysOn.Windows.Monitor.DatabaseReplica.SuspendState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.SystemPolicy | True | Public | |
| 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.2017.AlwaysOn.Windows.Monitor.DatabaseReplicaErrorPolicy.State | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaErrorUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.UserPolicy | 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.2017.AlwaysOn.Windows.Monitor.DatabaseReplicaWarningPolicy.State | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaWarningUserPolicy | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | False | | | False | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.UserPolicy | True | Public | |