Post reply

Service Broker Number of Conversation

  • October 14, 2010 at 5:30 am

    #230346

    Hi,

    I have a question about number of conversation.

    We create 1 conversation for all messages on Service Broker.

    At night we clear queue and create new conversation.

    Is it true method ?

    I have no idea about do we have performance problem in the future?

    Now we work on test server not production.

    Thanks for your reply..

  • October 14, 2010 at 7:38 am

    #1236848

    As usual: It depends. 😀

    There is simply not enough information available.

    For instance:

    Do you need to preserve order of operations?

    In what frequency do you receive new messages (each SEND locks the conversation exclusively...)?

    You might want to have a look at RUSANUs blog[/url] to look deeper into conversation handling.


    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]

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

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