Those of you at last months SQL Server unleashed events may remember Prem Maher form the SQL Customer Advisory Team (SQLCAT), talking about a whitepaper on virtualizing SQL Server, well it’s finally out and available here
This white paper, unlike some I have read, is a really deep study on the whole issue as you can see..
The scenario used, takes a 4 instance physical machine as a baseline under low medium and high workloads. The is then compared with virtualizing this setup as one virtual machine using Windows server Hyper-V, one one physical machine, and then with creating a virtual machine for each of the four instances and putting those on the same physical machine.
It is awash with detailed analysis of waits and throughput and is well worth ploughing through whether you’re using SQL Server 2005 or running SQL Server on another Virtualization platform (apparently there are others and they are even supported to run windows server 2008 and sql server 2008).
The key general recommendations are:
These are also good guidelines for any high performance application like Exchange, SharePoint etc. but don’t take my word for it or that of the SQL CAT, download the stuff and try it.