HADR_DB_OP_START_SYNC

Description

For databases utilizing Availability Groups. Occurs when Availability Group databases are waiting to update their runtime status. This wait type is uncommon. If values are detected see suggested solutions below.

Resolved by

DBAs

Suggested solutions

  1. Examine Windows Failover Clustering logs for any issues.
  2. Check the SQL Server error log for more information.
  3. 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