June 24, 2014 at 11:04 pm
Hi SQL Master,
I would like to ask you about Service Broker. It is urgent.
My production database suffers from Large message queue which is around 2 million ... I would like to decrease it as small as possible
I have done dbcc dbreindex('sys.queue_messages_245575913')
using DAC connection..but when I check again into the Queue properties ..the queue number remain the same..
Please kindly advice ....Really appreciate it
thank you
Mimi
June 25, 2014 at 2:06 pm
Is this the transmission queue or the receiving queue?
It sounds like your process isn't ending conversations.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 25, 2014 at 2:32 pm
There's a number of reasons your queue could be overloading.
Not enough processing, no activation proc (or error), endpoint not responsive, conversations not ending (as above), ...
Service Broker is an on-hand troubleshoot for locating the generic issue. If you nail it down to a particular point we can help you out but you've basically got to trace the entire message stream and figure out exactly what's going wrong. There may not even be an error, someone could have simply forgotten to turn it on.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 25, 2014 at 7:17 pm
HI... Thanks for the response..Appreciate it ..
How do I check that it has not "End Conversation"
Would you guide me on this?
It is not me the developer though...
Thanks so much 🙂
-Me
June 25, 2014 at 7:19 pm
Hi Thanks for the response...Much appreciate it ...
How do I turn it on ? Or maybe how do i check it is on or off...Really hv no idea about this ...
and How do I check the error message ?
Thanks heaps
June 26, 2014 at 6:20 am
murnilim9 (6/25/2014)
HI... Thanks for the response..Appreciate it ..How do I check that it has not "End Conversation"
Would you guide me on this?
It is not me the developer though...
Thanks so much 🙂
-Me
The End Conversation in my original post is a link, start by reading that article.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply