InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 05:27:13 GMT20http://www.sqlservercentral.com/Forums/Topic1281889-391-1.aspx[quote][b]logicinside22 (4/11/2012)[/b][hr]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_timeoutAny idea what steps to take resolve this issue?Thanks[/quote]Hi logicinside22,Did you find a solution? I am also seeing this query last days. RegardsWed, 14 Nov 2012 01:51:16 GMTBoris Pazinhttp://www.sqlservercentral.com/Forums/Topic1281889-391-1.aspx[quote][b]Ankit.shah22 (4/11/2012)[/b][hr]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_timeoutAny idea what steps to take resolve this issue?[/quote]Trace the query, see what is really doing.Look at wait events and execution plan.Wed, 11 Apr 2012 13:14:52 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic1281889-391-1.aspxHi 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_timeoutAny idea what steps to take resolve this issue?ThanksWed, 11 Apr 2012 12:57:28 GMTlogicinside22