Posted by: Denny Cherry
Service Broker, SQL Server 2005, 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
group by state_desc, far_service
ORDER BY far_service, state_desc
Hopefuly you find this helpful.