Home Forums SQL Server 2008 SQL Server 2008 - General Query consumes high CPU and 285 Sec avg duration RE: Query consumes high CPU and 285 Sec avg duration

  • 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