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

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 1 for SQL Server 2016 Service Pack 1 (SP1)

Cumulative Update 4 for SQL Server 2016

About the cumulative update


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.
Properties

Article ID: 3213288 - Last Review: 2017 Yanv 17 - Revision: 7

Fikr-mulohaza