HADR_LOGCAPTURE_SYNC

Description

For databases utilizing Availability Groups. This wait accumulates when the log capture mechanism (used to send/receive changes between primary and secondaries) is synchronizing. Synchronize events typically happen post-failover or after a replica loses connection then comes back online. This is a common wait, small values are acceptable but excessive values should be investigated.

Resolved by

DBAs

Suggested solutions

  1. Check the SQL Server error log for more information
  2. Examine wait statistics on the instance for other Availability Group issues. Investigate accordingly

Additional research

AlwaysOn Availability Groups Troubleshooting and Monitoring Guide

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index