HADR_LOGPROGRESS_SYNC

Description

For databases utilizing Availability Groups. This wait accumulates when replicas are processing log records and SQL Server needs to wait for replicas to synchronize internally. 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

⇐ Back to index