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.
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 otherwise.
In this availability group, at least one availability replica does not currently have the primary or secondary role.
Find the availability replica whose role is not primary or secondary 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 | Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityReplicaRoleState |
Algorithm | WorstOf |
Source Monitor | Microsoft.SQLServer.Linux.Monitor.AvailabilityGroupHealth.AvailabilityReplicaRoleState |
Relationship | Microsoft.SQLServer.Linux.AvailabilityGroupReferencesAvailabilityGroupHealth |
Category | AvailabilityHealth |
Enabled | True |
Alert Generate | False |
Alert Auto Resolve | True |
Remotable | True |
Accessibility | Public |
<DependencyMonitor ID="Microsoft.SQLServer.Linux.Rollup.AvailabilityGroup.AvailabilityReplicaRoleState" Accessibility="Public" Enabled="true" Target="SqlCoreLib!Microsoft.SQLServer.Core.AvailabilityGroup" ParentMonitorID="SqlCoreLib!Microsoft.SQLServer.Core.Rollup.AvailabilityGroup.AvailabilityReplicaRoleState" Remotable="true" Priority="Normal" RelationshipType="SqlDiscL!Microsoft.SQLServer.Linux.AvailabilityGroupReferencesAvailabilityGroupHealth" MemberMonitor="Microsoft.SQLServer.Linux.Monitor.AvailabilityGroupHealth.AvailabilityReplicaRoleState">
<Category>AvailabilityHealth</Category>
<Algorithm>WorstOf</Algorithm>
<MemberUnAvailable>Warning</MemberUnAvailable>
</DependencyMonitor>