Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Broker_Receive_Waitfor RE: Broker_Receive_Waitfor

  • 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]