I am looking into performance improvements for a SQL DWH VM using SCOM, vSphere performances counters and VMT. The server has 4 CPU, but we have tried 2\4\8\12 CPU’s. VMT is telling me the 4CPU Rdy msec is about 0.6% utilisation and 128 used. SCOM is saying there is zero processor queue. However when I look at the host performance for all its VMs the CPU ready queue for the SQL DWH VM ranges between 3386-30899 milliseconds (see attachment). This seems very high.
Therefore should I change the Utilization constraint for Host Ready Queue Utilization from the default of 100?