Post reply

SB Counter

  • October 27, 2009 at 12:58 pm

    #136891

    Is there a way to check and see how many messages are being added to a service broker queue vs how many are being processed in sql server 2005 Standard Edition SP2?

    Thanks,

    Fraggle

  • October 27, 2009 at 1:30 pm

    #1071423

    Monitoring Service Broker?

    I would start here http://msdn.microsoft.com/en-us/library/ms166069(SQL.90).aspx

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • October 27, 2009 at 2:56 pm

    #1071468

    Thanks for the link. The perfmon counter showed that I am not actually processing the messages. So now I need to know why this one queue isn't processing any message, but instead just letting them pile up. The queue appears to be activated and running, so I don't understand.

    I really wish there was better documentation on this.

    Fraggle

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

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