Some availability replicas do not have a healthy role

Some availability replicas do not have a healthy role

 

Published: May 17, 2016

Updated: May 17, 2016

Applies To: SQL Server 2016

Policy NameAvailability Replicas Role State
IssueSome availability replicas do not have a healthy role.
CategoryWarning
FacetAvailability group

This policy rolls up the connection state of all availability replicas and checks if there are any availability replicas that are not in a healthy role. The policy is in an unhealthy state when any availability replica is neither primary nor secondary. The policy is otherwise in a healthy state.

System_CAPS_ICON_note.jpg Note


For this release of SQL Server 2016, information about possible causes and solutions is located at Some availability replicas do not have a healthy role on the TechNet Wiki.

In this availability group, at least one availability replica does not currently have the primary or secondary role.

Use the availability replica policy state to find the availability replica whose role is not primary or secondary, and then resolve the issue at the availability replica.

Overview of Always On Availability Groups (SQL Server)
Use the Always On Dashboard (SQL Server Management Studio)

Community Additions

ADD
Show:
© 2016 Microsoft