SQL and virtual technologies

Published Friday, November 14, 2008 3:48 PM

Last night I was at the Ottawa SQL Group event helping out and I found out an interesting tidbit. This tidbit is only for production environments only, in Dev or in test labs, anything goes.

SQL 2000 are NOT supported under at virtualization product!

Now some people are going to asked about SQL 2005 & 2008, yes it is supported HOWEVER there is only one supported configuration (for MS Virtualization technologies, we didn’t talk about VMware so that one is still within “grey” area)

SQL 2005 & 2008 is only supported on Hyper-v!

SQL 2005 & 2008 is only supported if you used pass through disks!

 

Having said this people are going to ask for supporting docs, where here are a few:

 

SQL 2008

http://blogs.technet.com/mattmcspirit/archive/2008/10/07/sql-server-2008-on-hyper-v-best-practices-and-performance-considerations.aspx

 

Running SQL Server 2008 in a Hyper-V Environment - Best Practices and Performance Considerations

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/SQL2008inHyperV2008.docx

 

Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment

http://support.microsoft.com/?id=956893

Read the complete post at http://feedproxy.google.com/~r/smsug/xUOI/~3/12iwSQhqdf0/sql-and-virtual-technologies.aspx

This Blog

Archives

Syndication