Performance Monitor % Processor Time metric difference between _Total and sqlservr.exe
0
votes
1
answer
505
views
I have SQL Server running on 32-core CPU, and I use Performance Monitor (perfmon.msc) to collect data on Processor: % Processor Time (Instance - _Total) and Process: % Processor Time (Instance - sqlservr.exe)
So for example for day 2019/07/21 (Sunday), it shows average values:
Processor: % Processor Time (Instance - _Total) - 3.959
Process: % Processor Time (Instance - sqlservr.exe) - 107.312
Why is such a difference ?
I expected sqlservr.exe to show values like 2.900 or 3.100 - something like this, but not 107.312
How to correlate _Total to sqlservr.exe ?
I am using MaxDOP limited to 8 server level setting on SQL Server, if this is any help
Asked by Aleksey Vitsko
(6195 rep)
Jul 22, 2019, 10:55 AM
Last activity: Jul 22, 2019, 11:15 AM
Last activity: Jul 22, 2019, 11:15 AM