| | 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 (Windows 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.2017.AlwaysOn.Windows.Rollup.AvailabilityGroup.AllAvailabilityReplicasAreConnected | Microsoft.SQLServer.2017.AlwaysOn.Library.AvailabilityGroup | Microsoft.SQLServer.2017.AlwaysOn.Library.Rollup.AvailabilityGroup.AllAvailabilityReplicasAreConnected | WorstOf | | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AllAvailabilityReplicasAreConnected | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | | | False | True | Public |
| Availability Group Automatic Failover (Windows 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.2017.AlwaysOn.Windows.Rollup.AvailabilityGroup.AutomaticFailoverReadiness | Microsoft.SQLServer.2017.AlwaysOn.Library.AvailabilityGroup | Microsoft.SQLServer.2017.AlwaysOn.Library.Rollup.AvailabilityGroup.AutomaticFailoverReadiness | WorstOf | | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AutomaticFailoverReadiness | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | | | False | True | Public |
| Availability Group Online (Windows 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.2017.AlwaysOn.Windows.Rollup.AvailabilityGroup.AvailabilityGroupOnline | Microsoft.SQLServer.2017.AlwaysOn.Library.AvailabilityGroup | Microsoft.SQLServer.2017.AlwaysOn.Library.Rollup.AvailabilityGroup.AvailabilityGroupOnline | WorstOf | | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AvailabilityGroupOnline | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | | | False | True | Public |
| Availability Group Extended Health State (Windows 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 on Windows. | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rollup.AvailabilityGroup.AvailabilityGroupUserPolicyState | Microsoft.SQLServer.2017.AlwaysOn.Library.AvailabilityGroup | Microsoft.SQLServer.2017.AlwaysOn.Library.Rollup.AvailabilityGroup.AvailabilityGroupUserPolicyState | WorstOf | | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rollup.AvailabilityGroupHealth.UserPolicyAggregate | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | | | False | True | Public |
| Availability Group Critical Policies (Windows 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.2017.AlwaysOn.Windows.Rollup.AvailabilityGroup.AvailabilityReplicaRoleState | Microsoft.SQLServer.2017.AlwaysOn.Library.AvailabilityGroup | Microsoft.SQLServer.2017.AlwaysOn.Library.Rollup.AvailabilityGroup.AvailabilityReplicaRoleState | WorstOf | | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicaRoleState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | | | False | True | Public |
| Synchronous Replicas Data Synchronization (Windows 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.2017.AlwaysOn.Windows.Rollup.AvailabilityGroup.AvailabilityReplicasSynchronizationState | Microsoft.SQLServer.2017.AlwaysOn.Library.AvailabilityGroup | Microsoft.SQLServer.2017.AlwaysOn.Library.Rollup.AvailabilityGroup.AvailabilityReplicasSynchronizationState | WorstOf | | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizationState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | | | False | True | Public |
| Availability Replicas Data Synchronization (Windows 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.2017.AlwaysOn.Windows.Rollup.AvailabilityGroup.AvailabilityReplicasSynchronizing | Microsoft.SQLServer.2017.AlwaysOn.Library.AvailabilityGroup | Microsoft.SQLServer.2017.AlwaysOn.Library.Rollup.AvailabilityGroup.AvailabilityReplicasSynchronizing | WorstOf | | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizing | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | | | False | 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.2017.AlwaysOn.Windows.Rollup.AvailabilityGroupHealth.ErrorUserPolicyState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealth | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rollup.AvailabilityGroupHealth.UserPolicyAggregate | WorstOf | | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupErrorPolicy.State | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealthHostsAvailabilityGroupErrorUserPolicy | 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.2017.AlwaysOn.Windows.Rollup.AvailabilityGroupHealth.WarningUserPolicyState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealth | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rollup.AvailabilityGroupHealth.UserPolicyAggregate | WorstOf | | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupWarningPolicy.State | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealthHostsAvailabilityGroupWarningUserPolicy | AvailabilityHealth | True | False | | | False | True | Public |
| Availability Replica Critical Policies Availability | Rolls up all Availability Replica Critical Policies availability monitors to the Availability Replica. | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaAvailability | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsAvailabilityReplicaErrorUserPolicy | AvailabilityHealth | True | False | | | False | True | Public |
| Availability Replica Critical Policies Configuration | Rolls up all Availability Replica Critical Policies configuration monitors to the Availability Replica. | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaConfiguration | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsAvailabilityReplicaErrorUserPolicy | ConfigurationHealth | True | False | | | False | True | Public |
| Availability Replica Critical Policies Performance | Rolls up all Availability Replica Critical Policies performance monitors to the Availability Replica. | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaPerformance | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsAvailabilityReplicaErrorUserPolicy | PerformanceHealth | True | False | | | False | True | Public |
| Availability Replica Critical Policies Security | Rolls up all Availability Replica Critical Policies security monitors to the Availability Replica. | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaSecurity | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsAvailabilityReplicaErrorUserPolicy | SecurityHealth | True | False | | | False | True | Public |
| Availability Replica Warning Policies Availability | Rolls up all Availability Replica Warning Policies availability monitors to the Availability Replica. | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaAvailability | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsAvailabilityReplicaWarningUserPolicy | AvailabilityHealth | True | False | | | False | True | Public |
| Availability Replica Warning Policies Configuration | Rolls up all Availability Replica Warning Policies configuration monitors to the Availability Replica. | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaConfiguration | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsAvailabilityReplicaWarningUserPolicy | ConfigurationHealth | True | False | | | False | True | Public |
| Availability Replica Warning Policies Performance | Rolls up all Availability Replica Warning Policies performance monitors to the Availability Replica. | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaPerformance | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsAvailabilityReplicaWarningUserPolicy | PerformanceHealth | True | False | | | False | True | Public |
| Availability Replica Warning Policies Security | Rolls up all Availability Replica Warning Policies security monitors to the Availability Replica. | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaSecurity | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsAvailabilityReplicaWarningUserPolicy | SecurityHealth | True | False | | | False | True | Public |
| Database Replicas Availability | Rolls up all Database Replicas availability monitors to the Availability Replica. | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaAvailability | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsDatabaseReplica | AvailabilityHealth | True | False | | | False | True | Public |
| Database Replicas Configuration | Rolls up all Database Replicas configuration monitors to the Availability Replica. | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaConfiguration | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsDatabaseReplica | ConfigurationHealth | True | False | | | False | True | Public |
| Database Replicas Performance | Rolls up all Database Replicas performance monitors to the Availability Replica. | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaPerformance | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsDatabaseReplica | PerformanceHealth | True | False | | | False | True | Public |
| Database Replicas Security | Rolls up all Database Replicas security monitors to the Availability Replica. | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaSecurity | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsDatabaseReplica | SecurityHealth | True | False | | | False | True | Public |
| Database Replica Critical Policies Availability | Rolls up all Database Replica Critical Policies availability monitors to the Database Replica. | Microsoft.SQLServer.2017.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaAvailability | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaHostsDatabaseReplicaErrorUserPolicy | AvailabilityHealth | True | False | | | False | True | Public |
| Database Replica Critical Policies Configuration | Rolls up all Database Replica Critical Policies configuration monitors to the Database Replica. | Microsoft.SQLServer.2017.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaConfiguration | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaHostsDatabaseReplicaErrorUserPolicy | ConfigurationHealth | True | False | | | False | True | Public |
| Database Replica Critical Policies Performance | Rolls up all Database Replica Critical Policies performance monitors to the Database Replica. | Microsoft.SQLServer.2017.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaPerformance | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaHostsDatabaseReplicaErrorUserPolicy | PerformanceHealth | True | False | | | False | True | Public |
| Database Replica Critical Policies Security | Rolls up all Database Replica Critical Policies security monitors to the Database Replica. | Microsoft.SQLServer.2017.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaSecurity | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaHostsDatabaseReplicaErrorUserPolicy | SecurityHealth | True | False | | | False | True | Public |
| Database Replica Warning Policies Availability | Rolls up all Database Replica Warning Policies availability monitors to the Database Replica. | Microsoft.SQLServer.2017.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaAvailability | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | System.Health.AvailabilityState | WorstOf | | System.Health.AvailabilityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaHostsDatabaseReplicaWarningUserPolicy | AvailabilityHealth | True | False | | | False | True | Public |
| Database Replica Warning Policies Configuration | Rolls up all Database Replica Warning Policies configuration monitors to the Database Replica. | Microsoft.SQLServer.2017.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaConfiguration | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | System.Health.ConfigurationState | WorstOf | | System.Health.ConfigurationState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaHostsDatabaseReplicaWarningUserPolicy | ConfigurationHealth | True | False | | | False | True | Public |
| Database Replica Warning Policies Performance | Rolls up all Database Replica Warning Policies performance monitors to the Database Replica. | Microsoft.SQLServer.2017.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaPerformance | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | System.Health.PerformanceState | WorstOf | | System.Health.PerformanceState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaHostsDatabaseReplicaWarningUserPolicy | PerformanceHealth | True | False | | | False | True | Public |
| Database Replica Warning Policies Security | Rolls up all Database Replica Warning Policies security monitors to the Database Replica. | Microsoft.SQLServer.2017.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaSecurity | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | System.Health.SecurityState | WorstOf | | System.Health.SecurityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaHostsDatabaseReplicaWarningUserPolicy | SecurityHealth | True | False | | | False | True | Public |
Home