Post reply

Problem with ServiceBroker Queue

  • November 24, 2011 at 10:05 am

    #248544

    Hi All,

    We are using a serviceBroker queue for updating the message status updates into the database. And for some reason after every 2 months the servicebroker queue is getting overloaded and the updates are not happening. when i checked the rows in SBqueue there are almost 2 lakh records. and after i deleted all those rows it started working. Iam not able to get the root cause for the issue.Kindly help me on the same. I want to know the scenarious what might cause for such type of issue.It could be a gr8 help.

    Thanks,

    Ram

  • November 24, 2011 at 3:12 pm

    #1412806

    If the queue is "overloaded" it usually means there is no process receiving the messages.

    Deleting the queue is not really the way the messages should be "cleared".

    Rusanus blog[/url] might help you to find the root cause and ways to fix it.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • November 28, 2011 at 5:51 am

    #1413376

    LutzM (11/24/2011)

    If the queue is "overloaded" it usually means there is no process receiving the messages.

    Deleting the queue is not really the way the messages should be "cleared".

    Rusanus blog[/url] might help you to find the root cause and ways to fix it.

    Just to add what Lutz said, Deleting the queue messages are as good as loosing logs for database. For Example if it's Call Centre request queue you are basically loosing 2 lakh Service Requests or Business Leads if it's Marketing Application.

  • November 28, 2011 at 6:05 am

    #1413382

    Someone else already pointed you to Rusano's blog, but I want to point you specifically to this one:

    http://rusanu.com/2010/03/09/dealing-with-large-queues/

    It describes just the kind of issue you're having.

    [font="Verdana"]Markus Bohse[/font]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply