Nov 6 2008 11:00AM GMT
Posted by: mrdenny
SQL Server 2005, Service Broker, SQL Server 2008, sys.conversation_endpoints
Very useful little query to monitor the health of service broker
Posted by: mrdenny
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



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