SQL Server with Mr. Denny:

sys.conversation_endpoints

1

November 6, 2008  11:00 AM

Very useful little query to monitor the health of service broker



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

1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: