FIX: DMV sys.dm_hadr_availability_replica_states returns an incorrect synchronization health state for a distributed availability group

Dotyczy: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core

Symptoms


You create a distributed availability group in Microsoft SQL Server 2016 and then install the cumulative update 1 (CU1) for SQL Server 2016. However, when you query the DMV sys.dm_hadr_availability_replica_states primary replica of the primary availability group, incorrect result is returned. Specifically, the value in the synchronization_health column doesn't match the value in the synchronization_health_desc column. For example, if the value in the synchronization_health column returns 2, the value in the synchronization_health_desc column may return NOT_HEALTHY.


Resolution


This issue is fixed in the following cumulative updates for SQL Server:

Cumulative Update 2 for SQL Server 2016 SP1

Cumulative Update 4 for SQL Server 2016
 

 

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.