Home
  •  

Availability Replicas Connection (Linux rollup)

Microsoft.SQLServer.Linux.Rollup.AvailabilityGroup.AllAvailabilityReplicasAreConnected (DependencyMonitor)

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.

Knowledge Base article:

Summary

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.

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 MonitorMicrosoft.SQLServer.Core.Rollup.AvailabilityGroup.AllAvailabilityReplicasAreConnected
AlgorithmWorstOf
Source MonitorMicrosoft.SQLServer.Linux.Monitor.AvailabilityGroupHealth.AllAvailabilityReplicasAreConnected
RelationshipMicrosoft.SQLServer.Linux.AvailabilityGroupReferencesAvailabilityGroupHealth
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveTrue
RemotableTrue
AccessibilityPublic

Source Code:

<DependencyMonitor ID="Microsoft.SQLServer.Linux.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="SqlDiscL!Microsoft.SQLServer.Linux.AvailabilityGroupReferencesAvailabilityGroupHealth" MemberMonitor="Microsoft.SQLServer.Linux.Monitor.AvailabilityGroupHealth.AllAvailabilityReplicasAreConnected">

  <Category>AvailabilityHealth</Category>

  <Algorithm>WorstOf</Algorithm>

  <MemberUnAvailable>Warning</MemberUnAvailable>

</DependencyMonitor>