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

Query consumes high CPU and 285 Sec avg duration Expand / Collapse
Author
Message
Posted Wednesday, April 11, 2012 12:57 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 12:04 PM
Points: 321, Visits: 1,277
Hi all,
This service broker query consumes high CPU above 80% and ave duration is 285 sec.
WAITFOR(RECEIVE conversation_handle, service_contract_name, message_type_name, message_body FROM ExternalMailQueue INTO @msgs), TIMEOUT @rec_timeout

Any idea what steps to take resolve this issue?
Thanks


Aim to inspire rather than to teach.
SQL Server DBA
Post #1281889
Posted Wednesday, April 11, 2012 1:14 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
Ankit.shah22 (4/11/2012)
Hi all,
This service broker query consumes high CPU above 80% and ave duration is 285 sec.
WAITFOR(RECEIVE conversation_handle, service_contract_name, message_type_name, message_body FROM ExternalMailQueue INTO @msgs), TIMEOUT @rec_timeout

Any idea what steps to take resolve this issue?


Trace the query, see what is really doing.
Look at wait events and execution plan.


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #1281907
Posted Wednesday, November 14, 2012 1:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 20, 2014 3:33 AM
Points: 30, Visits: 182
logicinside22 (4/11/2012)
Hi all,
This service broker query consumes high CPU above 80% and ave duration is 285 sec.
WAITFOR(RECEIVE conversation_handle, service_contract_name, message_type_name, message_body FROM ExternalMailQueue INTO @msgs), TIMEOUT @rec_timeout

Any idea what steps to take resolve this issue?
Thanks


Hi logicinside22,

Did you find a solution? I am also seeing this query last days.

Regards
Post #1384460
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse