KB4013111 - 修复：DMV sys.dm_hadr_availability_group_states 在 SQL Server 次要副本synchronization_health_desc列中显示“NOT_HEALTHY”

应用对象

SQL Server 2012 Enterprise SQL Server 2012 Developer SQL Server 2012 Enterprise Core SQL Server 2012 Standard SQL Server 2014 Developer - duplicate (do not use) SQL Server 2014 Enterprise - duplicate (do not use) SQL Server 2014 Enterprise Core - duplicate (do not use) SQL Server 2014 Standard - duplicate (do not use) SQL Server 2014 Service Pack 2 - duplicate (do not use) SQL Server 2016 Developer - duplicate (do not use) SQL Server 2016 Enterprise - duplicate (do not use) SQL Server 2016 Enterprise Core - duplicate (do not use) SQL Server 2016 Standard - duplicate (do not use) SQL Server 2016 Service Pack 1

症状

你 (DMV) 针对 Microsoft SQL Server Always On 可用性组的辅助副本 (replica) 运行sys.dm_hadr_availability_group_states动态管理视图。在这种情况下，即使副本 (replica) 正常，DMV 也始终在synchronization_health_desc列中显示“NOT_HEALTHY”。