FIX: It takes longer to run the ALTER DATABASE SET HADR OFF command on a secondary replica in SQL Server 2014

Applies to: SQL Server 2014 DeveloperSQL Server 2014 DeveloperSQL Server 2014 Enterprise

Symptoms


Assume that you use the AlwaysOn Availability Groups feature in Microsoft SQL Server 2014. When you run the ALTER DATABASE SET HADR OFF command on a secondary replica, it takes longer than expected to finish. Additionally, the execution might be time out.

Resolution


The issue was first fixed in the following cumulative updates of SQL Server:

Status


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