Query consumes high CPU and 285 Sec avg duration

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Query consumes high CPU and 285 Sec avg...

Query consumes high CPU and 285 Sec avg duration

Rate Topic

Display Mode

Topic Options

Author

Message

logicinside22

Posted Wednesday, April 11, 2012 12:57 PM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 12:19 PM
Points: 280, Visits: 1,028

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

PaulB-TheOneAndOnly

Posted Wednesday, April 11, 2012 1:14 PM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:56 PM
Points: 3,016, Visits: 4,469

Ankit.shah22 (4/11/2012)

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

Boris Pazin

Posted Wednesday, November 14, 2012 1:51 AM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 1:56 PM
Points: 22, Visits: 129

logicinside22 (4/11/2012)

Hi logicinside22,

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

Regards

Post #1384460

« Prev Topic | Next Topic »

Permissions