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.
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 |
Rollup Algorithm | Defines the health state of the dependency rollup monitor to reflect either the least healthy state or the most healthy state of any member. | Best state of any member |
Target | Microsoft.SQLServer.Core.AvailabilityGroup |
Parent Monitor | Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AllAvailabilityReplicasAreConnected |
Algorithm | BestOf |
Source Monitor | Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AllAvailabilityReplicasAreConnected |
Relationship | Microsoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth |
Category | AvailabilityHealth |
Enabled | True |
Alert Generate | False |
Alert Auto Resolve | True |
Remotable | True |
Accessibility | Public |
<DependencyMonitor ID="Microsoft.SQLServer.Windows.Rollup.AvailabilityGroup.AllAvailabilityReplicasAreConnected" Accessibility="Public" Enabled="true" Target="SqlCoreLib!Microsoft.SQLServer.Core.AvailabilityGroup" ParentMonitorID="SqlCoreLib!Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AllAvailabilityReplicasAreConnected" Remotable="true" Priority="Normal" RelationshipType="SqlDiscW!Microsoft.SQLServer.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth" MemberMonitor="Microsoft.SQLServer.Windows.Monitor.AvailabilityGroupHealth.AllAvailabilityReplicasAreConnected">
<Category>AvailabilityHealth</Category>
<Algorithm>BestOf</Algorithm>
<MemberUnAvailable>Warning</MemberUnAvailable>
</DependencyMonitor>