BROKER_TRANSMISSION_WORK

Description

For databases using Service Broker. This wait accumulates while Service Broker is processing messages for transmission. This wait was introduced in SQL Server 2012, is common and currently is not documented by Microsoft. High values indicate normal activity

Resolved by

DBAs

Suggested solutions

  1. If values are excessively high, ensure Service Broker objects are designed as per best practice (link below)

Additional research

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

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