HADR_WORK_QUEUE

Description

SQL Server dedicates threads for databases participating in Availability Groups. This wait type accumulates while these threads are waiting for tasks to be assigned to them. As it is an idling wait high values are expected and can be ignored

Resolved by

DBAs

Suggested solutions

  1. Safe to ignore

Additional research

Monitor SQL Server AlwaysOn Availability Groups
MSDN Blog: Monitor Performance for AlwaysOn Availability Groups

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