October 22, 2010 at 3:49 am
I need to create an email alert to notify me for High CPU utilization. I need the alert only to fire if the CPU is pegged at 100 % for more than 5 minutes. I know there are tools that can do this job for me. But, currently my Company is not interested in buying any third party tools.
How do I go about creating an alert ?? Thanx in Advance !
October 22, 2010 at 4:02 am
Under your SQL Agent, you can make use of the Alerts, configure it custom to CPU Util....with a threshold.
Configure the Response to notify an operator.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 22, 2010 at 4:07 am
I cannot find the CPU utilization under the alerts.. Is it under the performance condition alerts ?? Can you please explain...
October 22, 2010 at 5:26 am
You'll need to target WMI on the remote/local server to monitor CPU
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 22, 2010 at 5:30 am
What query do I use in WMI event alert ? Or any documentation suggestions ??
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply