Monitor CPU% usage by SQL Server instance

Question

How to Monitor CPU% usage per SQL Server instance

Answer 1

Hi MSTechie-7364,

You can use the following counters in the Performance Monitor to track CPU usage:

• Processor: % Privileged Time

If the Processor: % Privilege Time value is high, kernel mode processes are using a lot of processor time, the machine is busy executing basic operating system tasks and cannot run user processes and other applications, such as SQL Server. Using a more powerful processor can help. The recommended values for Processor: %Privilege Time are 5 to 10% , or maximum 30% of the % Total Processor Time

• Processor: %User Time

Corresponds to the percentage of time that the processor spends on executing user processes such as SQL Server. The recommended Processor: % User Time is below 70%.

• System: Processor Queue Length

Corresponds to the number of threads waiting for processor time. A processor bottleneck develops when threads of a process require more processor cycles than are available. If more than a few processes attempt to utilize the processor's time, you might need to install a faster processor.

In addition, you can also use sys.dm_os_ring_buffers view to find CPU usage.

Please refer to Monitor CPU usage on SQL Server and Azure SQL and Monitor CPU Usage for more details.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.