Query consumes high CPU and 285 Sec avg duration

• SQlLogic

  SSCrazy Eights

  Points: 9686

  More actions

  April 11, 2012 at 12:57 pm

  #267164

  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

• PaulB-TheOneAndOnly

  SSC Guru

  Points: 66772

  More actions

  April 11, 2012 at 1:14 pm

  #1472177

  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.

• Boris Pazin

  Ten Centuries

  Points: 1036

  More actions

  November 14, 2012 at 1:51 am

  #1558790

  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