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.
DennyContact the Author | Contact DCAC