SQL Server with Mr. Denny

Nov 6 2008   11:00AM GMT

Very useful little query to monitor the health of service broker



Posted by: mrdenny
SQL Server 2005, Service Broker, SQL Server 2008, sys.conversation_endpoints

While dealing with a SQL Server Service Broker issue I needed a quick easy way to see how backlogged the service broker was.  So I came up with this little query which is surprisingly effective.

select far_service, state_desc, count(*) messages
from sys.conversation_endpoints
group by state_desc, far_service
ORDER BY far_service, state_desc

Hopefuly you find this helpful.

Denny

Comment on this Post


You must be logged-in to post a comment. Log-in/Register