SQL 2005 VM on ESXi 4 will not use more CPU resources from host.
Posted on 2012-03-27
We have SQL 2005 running on Windows Server 2003 as a VM on an ESXi 4 host. The host started off with single socket 4 core CPU. Due to high CPU utilization, we added a second socket 4 core CPU. The VM is running by itself on the host. What is happening is, when you look at the CPU usage in windows its stilll high averaging 80%-90%. If you look at the performance tab of the VM in ESXi its also reporting 80% plus. However if you look at the performance tab of the host itself without any other VMs assigned, it only reports about 35% usage. The VM is set to 4 vCPU and the host itself has 2 socket of 4 core totaling 8. Any ideas?