HADR_BACKUP_QUEUE

Description

For databases utilizing Availability Groups. When backups are requested by a secondary replica the primary must receive a series of commands to ensure co-ordination. When the primary replica is waiting for commands it will accumulate this wait. Small values are expected 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

Active Secondaries: Backup on Secondary Replicas
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