I recently finished a whitepaper on the
performance of really big Oracle database virtual machines. I highly recommend that you take a look at the paper for the full details, but a quick summary is that performance of large database virtual machines is good. This round of testing was using vSphere 6.5 on four generations of four-socket Intel based servers. The biggest size virtual machine that could be run without using any of the hyperthreads was tested on each host and compared:
As the power of servers has increased, the performance of large virtual machines has also increased.
Another way of looking at the performance increases is to keep the size of the virtual machine the same, and move it from older to newer hardware. Specifically if you compare the performance of the same 40vCPU VM on Westmere-EX vs Broadwell-EX you find an increase in performance of 42%:
The older Westmere-EX based server had 10 cores per socket, so the 40 vCPU VM was using all the cores. The newer Broadwell-EX based server has 24 cores per socket, so the 40 vCPU VM fits easily. So in addition to the 40 vCPU VM performing 42% better, there is also room for more VMs on the Broadwell-EX server. CPU utilization of the Broadwell-EX server was just 42% when the 40 vCPU VM was fully utilized because the host has 96 cores.