I stumbled upon a nice white paper on the VMware blog concerning virtualizing SQL servers. The conclusion of the article (how surprising) is that in high workload scenario’s it can be really interesting and usefull to virtualize your Microsoft SQL database servers.
I really advise you to read the full article, because every situation is different but for those who are lazy:
Based on the test data presented in this paper, we can conclude that:
– As the number of virtual machines is increased ESX offers linear scaling of performance until the physical CPUs are saturated.
– Fairness in resource sharing makes ESX a robust platform for hosting and consolidating virtual machines running SQL Server workloads.
– While resources are available, the CPU load on the host has minimal impact on the performance of applications running in virtual machines on that host.
– Virtual machines get the resources they need when resources are not overcommitted. Resources not used by idle virtual machines are dynamically allocated to other virtual machines that need resources without affecting performance.