Brent Ozar - SQL Server DBA Rotating Header Image

SQL Server support on virtual servers

The Microsoft knowledge base article on SQL Server virtualization support just got an update.  Here’s the interesting part:

“Versions of SQL Server after SQL Server 2005 will incorporate full support for running on a supported guest operating system that is installed on a Windows Server 2008 Hyper-V virtual machine.”

That means SQL Server 2008 will be fully supported even as a virtual server - but only when it’s running inside Hyper-V. That gives Hyper-V a competitive advantage over VMware ESX.  Even if a company’s admins prefer to use VMware, they still might want to use Windows 2008 virtualization just to get full support when things break.

The interesting part to me is what comes next: hopefully, we’ll get virtualization support for Microsoft Project and Sharepoint running as virtual guests.  Those two have always been thorns in my side.