Tuesday, April 14, 2015

SQL Server view for monitoring open Service Broker conversations


SELECT conversation_handle
 ,is_initiator
 ,s.NAME AS 'local service'
 ,far_service
 ,sc.NAME 'contract'
 ,ce.state_desc
FROM sys.conversation_endpoints ce
LEFT JOIN sys.services s ON ce.service_id = s.service_id
LEFT JOIN sys.service_contracts sc ON ce.service_contract_id = sc.service_contract_id;

No comments:

Post a Comment