Systems Engineering and RDBMS

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.

One Response to “SQL Server and Virtualization”

  1. […] system or a datawarehousing/data mining system that requires heavy IO activity.  Read more over here.  If you have applications which do not tax the database that much and the IO is relatively less, […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: