I have been ask this question I would like to have a quality response. Please keep in mind the person asking the question is a database admin not a VMware expert. I have in mind what to say just need a good way to explain to him the way VMware works.
Dual X5650 2.67GHz HP DL380 72GB of RAM
The SQL server has 4 vCPU but is only using at the most about 1800 MHz. I think the disks would be more of an issue. Raid 5 SAS drive all local storage.
I have a question on how our ESX server platform works.
for example if we have a host that has 2 procs and each proc has 4 cores
and we create a single VM on that box and set that vm up so it has 1 cpu... will that CPU then consume or use 1 core of 1 proc?
The reason I am asking is I am doing some calculations on if we are really saving money if we move our sql server to 2 procs on a VM or if it would be cheaper to move it to a physical single proc 4 core machine. SQL license would be the same price but we would have 4 times the power.