HADR_DB_OP_COMPLETION_SYNC

Description

For databases utilizing Availability Groups. Used internally while replicas are waiting for message responses regarding Availability Group operations. This wait type is uncommon and should not be high

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. Investigate accordingly

Additional research

AlwaysOn Availability Groups Troubleshooting and Monitoring Guide

See more

Check out SpotLight, a free, cloud based SQL Server monitoring tool to easily detect, monitor, and solve SQL Server performance problems on any device

 


⇐ Back to index