• DECLARE @CPU_BUSY int,

    @IDLE int,

    @seconds int,

    @secondsString varchar(50)

    SELECT @CPU_BUSY = @@CPU_BUSY, @IDLE = @@IDLE

    WAITFOR DELAY ''000:00:01''

    set @seconds = 0

    WHILE (SELECT (@@CPU_BUSY - @CPU_BUSY)/((@@IDLE - @IDLE + @@CPU_BUSY - @CPU_BUSY) *

    1.00) *100 AS CPUBusyPct) > 80 AND @seconds < 55

    BEGIN

    set @seconds = @seconds + 1

    SELECT @CPU_BUSY = @@CPU_BUSY, @IDLE = @@IDLE

    WAITFOR DELAY ''000:00:01''

    if @seconds % 10 = 0

    BEGIN

    -- DO Something like send an email

    END

    END