Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Broker_Receive_Waitfor Expand / Collapse
Author
Message
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: Yesterday @ 9:42 AM
Points: 54, Visits: 1,264
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 (1 view, 17.00 KB)
Post #1565166
Posted Saturday, April 26, 2014 1:40 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:36 AM
Points: 7,125, Visits: 13,172
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
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