Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Broker_Receive_Waitfor Expand / Collapse
Posted Friday, April 25, 2014 10:29 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, October 17, 2016 6:12 AM
Points: 68, Visits: 1,710
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.

  Post Attachments 
Waits_201404251129.xls (2 views, 17.00 KB)
Post #1565166
Posted Saturday, April 26, 2014 1:40 PM



Group: General Forum Members
Last Login: Wednesday, February 10, 2016 11:50 AM
Points: 6,897, Visits: 13,559
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".

A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
Post #1565361
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse