Home
  •  

Availability Replicas Connection (rollup)

Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AllAvailabilityReplicasAreConnected (AggregateMonitor)

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.

Knowledge Base article:

Summary

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.

Causes

In this Availability Group, at least one secondary replica is not connected to the primary replica. The connected state is DISCONNECTED.

Resolutions

Find the Availability Replica which is DISCONNECTED using Availability Replica monitor state and resolve the issue at the Availability Replica.

Overridable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow.

Yes

Generates Alerts

Defines whether the workflow generates an Alert.

No

Element properties:

TargetMicrosoft.SQLServer.Core.AvailabilityGroup
Parent MonitorSystem.Health.AvailabilityState
AlgorithmWorstOf
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityWarning
Alert PriorityNormal
Alert Auto ResolveTrue
RemotableTrue
AccessibilityPublic
Alert Message
MSSQL: Availability Replica disconnected
The Availability Group {0} contains disconnected replicas.
Cluster Name: {1}
Primary Replica: {2}

Source Code:

<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>