Sample Header Ad - 728x90

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