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