This monitor rolls up the data synchronization state of all availability replicas in the availability group and check whether any availability replica’s synchronization is not operational. The monitor is unhealthy state if any of availability replica’s data synchronization state is NOT SYNCHRONIZING. The monitor is healthy state is none of availability replica’s data synchronization state is NOT SYNCHRONIZING.
In this availability group, at least one secondary replica has a NOT SYNCHRONIZING synchronization state and is not receiving data from the primary replica.
Find the availability replica with NOT SYNCHRONIZING state 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.2012.AlwaysOn.AvailabilityGroup |
Parent Monitor | System.Health.AvailabilityState |
Algorithm | WorstOf |
Source Monitor | Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicasSynchronizing |
Relationship | Microsoft.SQLServer.2012.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth |
Category | AvailabilityHealth |
Enabled | True |
Alert Generate | False |
Alert Auto Resolve | True |
Remotable | True |
Accessibility | Public |
<DependencyMonitor ID="Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicasSynchronizingRollup" Accessibility="Public" Enabled="true" Target="AlwaysOnDisc!Microsoft.SQLServer.2012.AlwaysOn.AvailabilityGroup" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" RelationshipType="AlwaysOnDisc!Microsoft.SQLServer.2012.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth" MemberMonitor="Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicasSynchronizing">
<Category>AvailabilityHealth</Category>
<Algorithm>WorstOf</Algorithm>
<MemberUnAvailable>Warning</MemberUnAvailable>
</DependencyMonitor>