Remove "Idle" in Bottleneck Analysis in "Average System Idle CPU Utilization" #88
Description
I was just looking at a Bottleneck Analysis report from a recent capture and saw this:
| Average System Idle CPU Utilization: | 59% |
|---|---|
| Average SQL CPU Utilization: | 3% |
| Average Resource Wait Time per Second: | 45996 ms (46 active threads on average) |
Actual CPU counters:
Counter Name Avg Max Min Server
Process(_Total)% Processor Time 397.534 401.112 320.248 \{servername}\
Process(Idle)% Processor Time 166.151 400.930 69.159 \{servername}\
It looks like the Average System Idle CPU Utilization is actually the non-Idle CPU util
Idle: 166/4=41.5
System (4*100-Idle): (400-166)=234, 234/4=58.5
I think the Bottleneck Analysis report form needs to be changed to remove “Idle” from this. Historically, this always showed overall System CPU and not Idle CPU, so not sure when this got changed and if it was intentional.