You are currently offline, waiting for your internet to reconnect

You experience slow synchronization between primary and secondary replicas in SQL Server 2012

Symptoms
You experience poor synchronization performance between a primary replica and a secondary replica in a Microsoft SQL Server 2012 AlwaysOn availability group.
Cause
This issue can occur if the availability mode for a replica is changed from asynchronous commit to synchronous commit.
Resolution

Service pack information for SQL Server 2012

To resolve this problem, obtain the latest service pack for SQL Server 2012. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2755533 How to obtain the latest service pack for SQL Server 2012
Workaround
To work around this issue, suspend the secondary replica while the synchronous replication mode is used. Then, resume the secondary replica.

Note This workaround reestablishes the data movement session and causes the thread to read the replication mode flag again.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
More information
To verify that you are experiencing the issue that is described in the "Symptoms" section, follow these steps.

Note When the session queries the sys.dm_exec_requests dynamic management view, the session performs DML against the availability databases. In this state, the prevalent reported waittype is HADR_SYNC_COMMIT.
  1. Start Performance Monitor.
  2. Track the following performance counters:
    • Availability Replica:Receives from Replica/Sec
    • Availability Replica:Sends to Replica/Sec
  3. Compare the statistics that are reported by the performance counters in step 2. If the statistics are not similar, you may be experiencing the issue that is described in the "Symptoms" section.

Properties

Article ID: 2723814 - Last Review: 12/27/2012 12:11:00 - Revision: 3.1

  • kbsurveynew kbprb kbfix kbqfe kbtshoot KB2723814
Feedback
CustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" /html>if?DI=4050&did=1&t=">nguage in languagesListForLargeScreens track by $index" class="col-sm-6 col-xs-24 ng-scope"> Venezuela - Español
/html>microsoft.com/c.gif?DI=4050&did=1&t="> var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" d')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> >