August 6, 2004 at 12:22 am
Folks, i want an alert to be displayed by SQL when the processor shoots above 80% constantly for 30 seconds. Is there any perfomance counter alert sepcifically for this purpose?
Performance monitor can be set to alert for the counter; but i couldn't find an option how to setup the alert if the counter is over a limit for a specific limit of time(eg if processor is constanly above 80 for last 30 secs). It gives actual counter value rather than average value. Any help??
Howdy!
__________________________________
A DBA works only when the users can't, so i scarcely work!
August 6, 2004 at 2:56 am
from books on-line
***********************
SQL Server Agent polls the performance counters at 20-second intervals.
Important Using a frequency higher than 20 seconds increases the processing overhead for SQL Server.
If a counter spikes for only a few seconds, which satisfies the performance condition, there is a high likelihood that SQL Server Agent will fail to see the spike; the alert will not fire.
*******************
so if you set your CPU usage settings then then chances of hitting an 80% spike are quite low, more likely you'll hit a sustained usage period
MVDBA
August 6, 2004 at 4:57 am
Hi, thanx for ur input.
I coudn't find an option of setting processor % time alert in SQL.
What i would like to know is if there's an option to get an alert when the counter satisifies a limit for a specific amount of time despite the overhead.
I want to know when the processor is above critical limit constantly for 1 or 2 mins.
__________________________________
A DBA works only when the users can't, so i scarcely work!
August 6, 2004 at 5:30 am
not as far as i'm aware.
but what you could do is set the idle state in SQL AGENT as below 80% for 2 minutes.
what you can then do is perform some sort of job based on that status (for example add a row into a table)
you can then set up a further job to check if this has happed.... that can then alert you to the CPU usage levels.
I know this is a bit crude, but i'm sure someone here could refine it..!!
MVDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply