BROKER_TASK_SHUTDOWN

Description

For databases using Service Broker. This wait accumulates while a Service Broker queue is shutting down. This wait is uncommon and currently not documented by Microsoft. Values should be minimal. If values are excessively high see the suggested solutions below

Resolved by

DBAs

Suggested solutions

  1. Ensure Service Broker objects are designed as per best practice (link below)
  2. Check the SQL Server error log for any Service Broker issues

Additional research

Service Broker: Performance and Scalability Techniques
How to troubleshoot Service Broker problems

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