Service Broker Troubleshooting
I've
gathered various posts discussing all kinds of problem and resolutions when
dealing with service broker.
A
very useful query for message pileup in the queue is this one (100% mine :-) ):
SELECT is_initiator,
s.name as 'local
service',
far_service,
count(*) as conversations,
sum(msg.messages) as messages
FROM
sys.conversation_endpoints ce
left join sys.services s on
ce.service_id = s.service_id
inner join (
SELECT count(*) as messages, conversation_handle
FROM [YOUR QUEUE NAME GOES HERE]
GROUP BY conversation_handle
) as msg on
msg.conversation_handle = ce.conversation_handle
GROUP BY is_initiator, s.name, far_service
Extenral link #1: Troubleshooting tools
External link #2: Troubleshooting
External link
#3: Conversation troubleshooting
External
link #4: Queries for troubleshooting