How would %privilege time of sqlsvr instance indicate cpu consumption of other processes?
0
votes
1
answer
365
views
I am looking at msdn doc to monitor cpu.
Link: https://learn.microsoft.com/en-us/troubleshoot/sql/performance/troubleshoot-high-cpu-usage-issues#step-1-verify-that-sql-server-is-causing-high-cpu-usage
It says I need to capture the %user time and %privileged time for sqlsvr instance.
Then it goes to say high %user time means sqlsvr is keeping cpu busy. Where as high %privileges time means other processes or anti-virus is keeping the cpu busy.
My question is - how would %privilege time of sqvsvr instance indicate cpu consumption of other processes?
Asked by variable
(3590 rep)
May 6, 2022, 08:46 PM
Last activity: May 6, 2022, 10:59 PM
Last activity: May 6, 2022, 10:59 PM