April 27, 2015 at 4:09 pm
I have an alert defined to notify me when the CPU rises above 75%. This never fires -- even when I change the percentage to 1%. I am using the following:
Type: SQL Server Performance Condition Alert
Object: Resource Pool Stats
Counter: CPU Usage %
Alert: Rises Above
Value: 75
I was able to change the alert to the following and it works, but can't enter any other value:
Type: SQL Server Performance Condition Alert
Object: Workload Group Stats
Counter: CPU Usage %
Alert: Rises Above
Value: 0 (where 0 = 1%, and 1 = 100%)
Does anyone have an alert that works to monitor CPU usage that works? I've not used WMI event alerts, and am hoping to stick with using the 'SQL Server Performance Condition Alert' type.
SQL Server Version: 2008 R2 (SP2)
April 28, 2015 at 10:02 am
I use a third party monitoring tool to monitor CPU utilization on servers, but I think in this case the solution is indicated by what you saw with the workload group stats, i.e., that SQL Server is treating that counter value as ranging between 0 and 1.
For 75%, try 0.75 for the counter value when the Object is Resource Pool Stats, Counter is CPU Usage %, and Instance is default.
That seems to work as expected in my quick test.
Cheers!
April 28, 2015 at 10:39 am
.75 is not a valid option for this counter -- only 75, and that is the example that I provided and it does not work. Thanks for looking at this though 🙂
April 28, 2015 at 11:43 am
Did you try 0.75, or just .75?
The latter will indeed throw an error. The former will not, at least not on the server I tested 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply