SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

SQL and virtual technologies

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

Comments

No Comments

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems