How to execute an SQL Server agent job when the server CPU usage is above 90%

Question

How to execute an SQL Server agent job when the server CPU usage is above 90%

Joy Smith San

SSC-Insane

Points: 24877
More actions
November 19, 2014 at 11:57 pm

#312721

Hi,
I wanto execute an SQL Server agent job when the server CPU usage is above 90%.
How can we do it ? Thanks in advance.
Smith.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

Normally I would say you could use a SQL Server Agent Alert with a performance condition, but it doesn't appear to work. Looks like it's a bug (so a MSFT moderator says on the msdn forums).

Here's an alternative method that relies on the os ring buffers: http://dba.stackexchange.com/questions/25527/collect-performance-information-on-high-cpu-condition-in-sql-server

You could schedule that check every x minutes and run the job using sp_start_job when the condition is met.

-- Gianluca Sartori