BROKER_SHUTDOWN

Description

For databases using Service Broker. This wait accumulates while a Service Broker is shutting down. As the Broker is often shutdown before the instance is stopped (when wait statistics are cleared) it is uncommon to detect this wait type. 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
  3. Investigate other Service Broker related wait types on the instance

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