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.
This monitor rolls up the connection state of all Availability Replica's and check whether any Availability Replica is DISCONNECTED. The monitor is unhealthy when any Availability Replica is DISCONNECTED. The monitor is healthy otherwise.
In this Availability Group, at least one secondary replica is not connected to the primary replica. The connected state is DISCONNECTED.
Find the Availability Replica which is DISCONNECTED using Availability Replica monitor state and resolve the issue at the Availability Replica.
Name | Description | Default Value |
Enabled | Enables or disables the workflow. | Yes |
Generates Alerts | Defines whether the workflow generates an Alert. | No |
Target | Microsoft.SQLServer.Core.AvailabilityGroup | ||
Parent Monitor | System.Health.AvailabilityState | ||
Algorithm | WorstOf | ||
Category | AvailabilityHealth | ||
Enabled | True | ||
Alert Generate | True | ||
Alert Severity | Warning | ||
Alert Priority | Normal | ||
Alert Auto Resolve | True | ||
Remotable | True | ||
Accessibility | Public | ||
Alert Message |
|
<AggregateMonitor ID="Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AllAvailabilityReplicasAreConnected" Accessibility="Public" Enabled="true" Target="Microsoft.SQLServer.Core.AvailabilityGroup" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal">
<Category>AvailabilityHealth</Category>
<AlertSettings AlertMessage="Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AllAvailabilityReplicasAreConnected.AlertMessage">
<AlertOnState>Warning</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertSeverity>Warning</AlertSeverity>
<AlertParameters>
<AlertParameter1>$Target/Property[Type="System!System.Entity"]/DisplayName$</AlertParameter1>
<AlertParameter2>$Target/Property[Type="Microsoft.SQLServer.Core.AvailabilityGroup"]/ClusterName$</AlertParameter2>
<AlertParameter3>$Target/Property[Type="Microsoft.SQLServer.Core.AvailabilityGroup"]/PrimaryReplicaServerName$</AlertParameter3>
</AlertParameters>
</AlertSettings>
<Algorithm>WorstOf</Algorithm>
</AggregateMonitor>