Post reply

Broker_Receive_Waitfor

  • April 25, 2014 at 10:29 am

    #396660

    I have a suspended process, performing a DELETE command. The last wait was on BROKER_RECEIVE_WAITFOR. Please see the attached xls for details. What should I do with that? Thanks.

  • April 26, 2014 at 1:40 pm

    #1708995

    The WAITFOR has a parameter @p2 for a timeout. What's the value of this parameter?

    The process did wait for 15+ seconds to get new data.

    Without knowing what is triggered by the service broker it's hard to tell how to deal with it... Uusally, it's not a big issue if a waitfor task got suspended. But as usual, "it depends".


    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