Process % Privileged Time does not account for multiple CPUs


The threshold file for SQL Server includes the counter for \Process(sqlservr)\% Privileged Time, but the defined thresholds (20% and 30%) don't seem to account for having multiple CPUs in the system. For example, I am analyzing some logs from a 24-core box and PAL is worried about having an average value of 37% here. However, since it is across 24 cores it actually is a fairly small value.

Is there a way in the PowerShell threshold cold to divide the value by the number of CPUs?
Closed Oct 3, 2013 at 6:57 PM by ClintH


ClintH wrote Feb 8, 2013 at 6:15 PM

Yes, you can use the $NumberOfProcessors variable in the code block of the thresholds. I thought I had this already in place in \Process(*)\% Processor Time analysis in SystemOverview.xml, but apparently it isn't there. I'll re-add it. In any case, yes, go ahead and change it.

wrote Feb 22, 2013 at 1:46 AM

HolisticDeveloper wrote Feb 26, 2013 at 6:55 PM

Given that I'm not super familiar with PowerShell, how should the threshold code be modified? Here is the existing code in the threshold:

StaticThreshold -CollectionOfCounterInstances $CollectionOfProcessPercentPrivilegedTimesqlservr -Operator 'gt' -Threshold 20

wrote Oct 3, 2013 at 6:57 PM