8

In Activity Monitor, the following query is causing high CPU and 281ms average duration.

WAITFOR (
RECEIVE conversation_handle
    , service_contract_name
    , message_type_name
    , message_body 
FROM ExternalMailQueue 
INTO @msgs
)
, TIMEOUT @rec_timeout

Any idea or steps how to resolve this?

  • I see you posted on SSC also. Did you follow any of the steps provided to that user? e.g. look through the logs? – swasheck Apr 11 '12 at 16:17
10

This is a red herring. WAITFOR (RECEIVE...) is by definition supposed to ... wait for messages! Therefore 281 seconds elapsed simply means that for 281 seconds there was no message to receive. In this case the application is the Database Mail external sending process that is sitting idle waiting for messages to be enqueued (ie. waits for sp_send_db_mail to be called). There is nothing to 'resolve' here.

  • Yep, agree completely - spot on! – Peter Schofield Apr 11 '12 at 21:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.