Sample Header Ad - 728x90

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