High CPU for SQL server running on VmWare I am trying to understand the below behavior for one of our SQL server running on VM.
SQL Server version 2017 has 64vCores and Host has 96 cores with base speed 2.1 GHZ
Based on the article from https://sqlperformance.com/2017/05/monitoring/troubleshooting-cpu-vmware i collected the counters and can see below&quot;-
Processor% Processor Time in Task Manager or perfmon: Toggles around 80 in peak business hours
% Processor Time for VM ware is always pegging around 100%
Effective VM speed MhZ averages around 140,305 so does not look to be limited anywhere. ( Minimum 8219 and maximum 157,612)
Host processor speed is 2091
Is there a way to find what does that 100% coming from? Or is that OK to be 100 % for that counter where SQL seems to be between 75-80%?
Additional info:-
Avg Batch re/sec on high time = 30K
Blocking/deadlocks= none
Queries are generally fast like 100K executions/min and avg CPU they spend is few ms.
Mostly all the above queries are single threaded due to various reasons.
CTOP= 200 and MAXDOP =8
Thanks
thats seems to be a lot of CPU being burned and should be approached IMHO.
Do you have any performance issue?
I would try sp_blitz https://www.brentozar.com/blitz/
and if you have querystore enabled, take a look at queries that eat up the CPU.