SQL Server and Virtualization
Posted by decipherinfosys on October 8, 2008
We have been writing about virtualization quite a bit. Most of our clients have migrated their web and application tiers to vmware/Hyper-V (or are contemplating to) because of the benefits that it offers but as far as the database tier is concerned in a production environment, there hasn’t been a mass adoption of it because of a couple of reasons – for the databases, IO is very important. If you have not done proper planning of building up a good IO path from your VM to your SAN device and if you are using vmotion, you can start seeing issues. vmotion is a very good technology and works great for print servers, file servers etc. but not for the databases. Our clients have been using it mostly in the development or test (QA) environments and for demo environments and only now have we started seeing some of them planning a move to the production environment as well. Before you do that though, you need to be aware of the best practices and performance implications of running SQL Server in a virtual environment.
While researching this topic more for our client, we saw this excellent whitepaper from the SQLCAT (Customer Advisory Team) which goes into the details of running SQL Server 2008 in a Hyper-V environment. We are in the process of setting it up and will be doing more tests on it and will post results on our blog.