Very useful little query to monitor the health of service broker
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. […]
Very useful little query to monitor the health of service broker
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. […]