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]