Home Forums Programming Service Broker I want to be able to stop my queue when there is a backlog... RE: I want to be able to stop my queue when there is a backlog...

  • dave.farmer (7/26/2012)


    ...

    I'm also curious as to the operation of the RECEIVE... when there are, say, 10 million messages in the queue, what will my activation procedure actually RECEIVE? Not all 10 million presumably - there are 32 threads processing this queue, I reuse each conversation handle for 1000 messages before retiring it.

    ...

    receive returns per call only the messages from a single conversation. So if you start a new conversation at every 1000th message, your receive will never return more than 1000 rows per call.



    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]


    If you don't have time to do it right, when will you have time to do it over?