CPU Utilization Unusual - Doesnt show usage per process

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A

CPU Utilization Unusual - Doesnt show usage per process

Postby samalex » Sat Feb 27, 2010 5:52 pm

Hi,

I'm using the 14 day demo of SQL Response 1.3 to monitor our various SQL Servers, and thus far I'm loving it. One problem though is it has given the 'CPU Utilization Unusual' Alert several times which is good to know, but when it lists the System Processors it only shows Process Name, ID, Start Time, Approx End Time, CPU Time, Mem Useage, and VM Size... but no CPU % Usage which is pretty important when this Alert is thrown to see what process is pegging the CPU.

Granted the SQL Service is generally running the longest and using the most RAM, but that doesn't mean it's pegging the CPU. Can someone suggest how to add % CPU Used to this list for each process? Or what about a pie chart like the one in the 'Low physical memory' Alert so we can see possibly the largest 5 or 6 processes chewing on the CPU.

So great Alert, but as-is after the CPU tapers back down it doesn't help me to know what Process caused the Alert :-/

Thanks --

Sam
samalex
 
Posts: 14
Joined: Sat Feb 27, 2010 5:45 pm

Postby peter.peart » Mon Mar 01, 2010 4:46 pm

Hi there,

Unfortuantely, this isn't available for version 1 of the tool. We are however already working on version 2 and this is in there. If you would like to have your say on what else makes it into V2, as well as get in the EAP list further information can be found from the below link:

http://www.thefutureofmonitoring.com/

HTH,

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests