BROKER_CONNECTION_RECEIVE_TASK

Description

For databases using Service Broker. As Service Broker endpoint access is serialized other processes must wait while messages are being read. When processes are blocked this wait will accumulate. Values should be minimal. If values are moderate to high see the suggested solutions below/p>

Resolved by

DBAs

Suggested solutions

    1. Reduce or consolidate the number of messages
    2. Ensure Service Broker objects are designed as per best practice (link below)
    3. 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