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"-
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%?
Avg Batch re/sec on high time = 30K
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