DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 956893 - Last Review: June 21, 2014 - Revision: 29.0

On This Page

INTRODUCTION

This article describes the support policy for Microsoft SQL Server products that are running in a hardware virtualization environment.

More information

Microsoft provides technical support for SQL Server 2005 and later versions for the following supported hardware virtualization environments:
  • Windows Server 2008 and later versions with Hyper-V 
  • Microsoft Hyper-V Server 2008 and later versions
  • Configurations that are validated through the Server Virtualization Validation Program (SVVP).

    For more information about certified vendors and about configurations for SVVP, visit the following SVVP website: 
    http://windowsservercatalog.com/svvp.aspx?svvppage=svvp.htm (http://windowsservercatalog.com/svvp.aspx?svvppage=svvp.htm)
    Note The SVVP solution must be running on hardware that is certified for Windows Server 2008 R2 or a later version to be considered a valid SVVP configuration.
Microsoft provides technical support for SQL Server 2008 and later versions for the following supported hardware virtualization environments:
  • Windows Azure Infrastructure Services which includes Windows Azure Virtual Machines and Windows Azure Virtual Network (See the Frequently Asked Questions section for more details)

Microsoft may provide limited or no technical support for the following environments:
  • Any version of SQL Server earlier than SQL Server 2005 (such as SQL Server 2000) that is running on any virtualization vendor or configuration.
  • Any non-Microsoft virtualization software that is not a configuration that is validated through the SVVP program

This policy of limited support is based on the following Microsoft Knowledge Base article:  
897615  (http://support.microsoft.com/kb/897615/ ) Support policy for Microsoft software running in non-Microsoft hardware virtualization software

Restrictions and Limitations

The following restrictions and limitations may affect the support policy of the above supported configurations:
  • Guest Failover Clustering is supported for SQL Server 2005 and later versions in a virtual machine for the supported hardware virtualization environments listed in this article provided all of the following requirements are met: 
    • The Operating System running in the virtual machine (the "Guest Operating System") is Windows Server 2008 or a later version.
    • The virtualization environment meets the requirements of Windows 2008 or Windows 2012 Failover Clustering, as documented in the following articles in the Microsoft Knowledge Base:  
      943984  (http://support.microsoft.com/kb/943984/ ) The Microsoft Support Policy for Windows Server 2008 Failover Clusters
      2775067  (http://support.microsoft.com/kb/2775067/ ) The Microsoft support policy for Windows Server 2012 failover clusters
  • The SQL Server product must be a supported version under its current Microsoft Support Lifecycle policy. For more information about Microsoft Support Lifecycle policies, visit the following Microsoft Support website: 
    http://support.microsoft.com/?pr=lifecycle (http://support.microsoft.com/?pr=lifecycle)
  • SQL Server supports virtualization-aware backup solutions that use VSS (volume snapshots). For example, SQL Server supports Hyper-V backup.

    Virtual machine snapshots that do not use VSS volume snapshots are not supported by SQL Server. Any snapshot technology that does a behind-the-scenes save of a VM’s point-in-time memory, disk, and device state without interacting with applications on the guest using VSS may leave SQL Server in an inconsistent state.
  • SQL Server on Hyper-V Replica is supported provided the EnableWriteOrderPreservationAcrossDisks (http://technet.microsoft.com/en-us/library/hh848543.aspx) flag is set.

    Note To set the EnableWriteOrderPreservationAcrossDisks flag, run the following cmdlet:

    Set-VMReplication -VMName <vm-name> -EnableWriteOrderPreservationAcrossDisks 1

    Exceptions

    If multiple SQL VMs are tightly coupled with one another, individual VMs can failover to the disaster recovery (DR) site but SQL high availability (HA) features inside the VM need to be removed and re-configured after VM failover. For this reason the following SQL Server features are not supported on Hyper-VM Replica: 
    • Availability Groups
    • Database mirroring
    • Failover Cluster instances
    • Log shipping
    • Replication

Frequently asked questions

Q1: What level of technical support will I receive if my non-Microsoft vendor configuration is certified through SVVP?

A1: Microsoft Customer Service and Support (CSS) will work together with the customer and the SVVP certified vendor to investigate the problem with SQL Server that is running in the virtual machine. Microsoft CSS or the SVVP vendor will follow the process that is documented on the following SVVP website to use the TSANet program together with the customer’s permission in an attempt to resolve the problem: 
http://windowsservercatalog.com/svvp.aspx?svvppage=svvpsupport.htm (http://windowsservercatalog.com/svvp.aspx?svvppage=svvpsupport.htm)

Q2: What if the non-Microsoft vendor virtualization configuration is not certified through SVVP?

A2: Microsoft CSS will follow the support policies that are documented in Knowledge Base article 897615. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
897615  (http://support.microsoft.com/kb/897615/ ) Support policy for Microsoft software running in non-Microsoft hardware virtualization software
If Microsoft CSS determines that the problem may be related to the vendor virtualization software, Microsoft CSS may require the customer to reproduce the problem outside the virtualization environment. It is important to carefully read about the configurations that are supported for SVVP at the following SVVP website:
http://www.windowsservercatalog.com/svvp/ (http://www.windowsservercatalog.com/svvp/)
Not all vendor configurations are considered certified by SVVP even though the vendor participates in the program. The list of validated configurations may be updated as vendors submit changes through this program.

Q3: The SVVP program specifically lists the valid configurations for Windows Server 2008. Are other versions of Windows supported to be used as guest operating system?

A3: Yes. As documented at the following SVVP website, the products that passed the SVVP requirements for Windows Server 2012 are considered supported on Windows Server 2008 R2 Windows Server 2008 and Windows Server 2003 SP2 and later Service Packs, both x86 and x64
http://windowsservercatalog.com/results.aspx?&bCatID=1521&cpID=0&avc=0&ava=0&avq=0&OR=1&PGS=25 (http://windowsservercatalog.com/results.aspx?&bCatID=1521&cpID=0&avc=0&ava=0&avq=0&OR=1&PGS=25 )
When running SQL Server on a guest operating system, the version of SQL Server must be supported on the version of the guest operating system, according to the requirements that are listed in the respective SQL Server product documentation.

For more information about the hardware and software requirements for SQL Server, visit the following Microsoft TechNet website: 

http://technet.microsoft.com/en-us/library/ms143506.aspx (http://technet.microsoft.com/en-us/library/ms143506.aspx)

Q4: Are SQL Server features such as database mirroring supported to run in a virtualization environment?

A4: The only restrictions to install and use SQL Server in a virtualization environment are documented in this article or in the SQL Server product documentation. Any feature or usage that is not stated in this article or in the SQL Server product documentation is assumed to be supported in a virtualization environment by using the same restrictions and support as a “bare metal” hardware environment. For more information about the features that are supported by different editions of SQL Server, visit following TechNet website:
http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx (http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx )
 These same requirements apply to SQL Server 2005 and later versions that are running in a virtualization environment.

Q5: Is Quick and Live Migration with Windows Server 2012 or Windows Server 2008 R2 Hyper-V supported with SQL Server?

A5: Yes, Live Migration is supported for SQL Server 2005 and later versions when used with Windows Server 2008 R2 or later versions with Hyper-V and with Hyper-V server 2008 R2 or later versions. Quick Migration, which was introduced with Windows Server 2008 with Hyper-V and Hyper-V Server 2008, is also supported for SQL Server (All versions from SQL Server 2005 and later) in Windows Server 2008 (or later versions) with Hyper-V and Hyper-V Server 2008  (or later versions).

Q6: What is the support policy for SQL Server when using a SVVP vendor virtualization feature such as snapshots or migration?

A6: Snapshots for any virtualization vendor that do not use VSS are not supported with SQL Server. Any other virtualization additional functionality of a SVVP vendor such as migration must be supported by the SVVP vendor. This includes any problems that might occur with SQL Server when using these features. Please read this resource for more information about the support policy for additional functionality of a virtualization product:
http://www.windowsservercatalog.com/svvp.aspx?svvppage=svvpsupport.htm (http://www.windowsservercatalog.com/svvp.aspx?svvppage=svvpsupport.htm)

Q7: Is Hyper-V Dynamic Memory supported for SQL Server?

A7: Hyper-V Dynamic Memory is fully supported with SQL Server. Only SQL Server versions and editions that support Hot Add Memory (Enterprise and Datacenter) can see memory that is added by using Hyper-V Dynamic Memory. SQL Server 2012 Standard edition also recognizes Hot Add memory when running in a virtual enviroment. SQL Server versions that do not support Hot Add Memory are still supported. But these versions will detect only the memory that is present in the operating system when SQL Server starts. Before you deploy Hyper-V Dynamic Memory, please read the following resources when you use Hyper-V Dynamic Memory with SQL Server:
Hyper-V Dynamic Memory Evaluation Guide (http://technet.microsoft.com/en-us/library/ff817651(WS.10).aspx)
SQLOS Team Blog - Hyper-V Dynamic Memory (http://blogs.msdn.com/b/sqlosteam/archive/tags/hyper_2d00_v+dynamic+memory/)
Windows Virtualization Team Blog - Dynamic Memory (http://blogs.technet.com/b/virtualization/archive/tags/dynamic+memory/)

Q8: Do you support SQL Server running in Windows Azure Virtual Machine?


A8:
 Yes. Microsoft supports SQL Server 2008 and later versions in Windows Azure Infrastructure Services which includes Windows Azure Virtual Machines and Windows Azure Virtual Network. Consider the following when you deploy SQL Server 2008 and later versions in Windows Azure Virtual Machine:
  • Windows Azure Storage’s Geo-Replication (http://blogs.msdn.com/b/windowsazurestorage/archive/2011/09/15/introducing-geo-replication-for-windows-azure-storage.aspx) is not supported if the data and log files of a database are stored in more than one disk.
  • AlwaysOn Availability Groups (with Listeners) (http://msdn.microsoft.com/en-us/library/windowsazure/jj870962.aspx)  fully supported.
  • AlwaysOn Failover Cluster Instances are not supported.
  • We recommend a medium or larger VM size.
  • For more information about Windows Azure Virtual Machine and SQL Server please see Getting started with SQL Server on a Windows Azure virtual machine. (http://go.microsoft.com/fwlink/?LinkID=242213)
Q9: Can customers run SQL Server in the Windows Azure VM role?

A9: Windows Azure VM role is a non-persistent role and not the same as Windows Azure Virtual Machine. It is not supported for SQL Server production use. Customers who want to deploy data platform capabilities today in the Windows Azure platform should use Windows Azure Virtual Machine or Windows Azure SQL Database.



Applies to
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Express Edition with Advanced Services
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
  • Microsoft SQL Server 2008 R2 Analysis Services
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 PowerPivot for Microsoft Excel 2010
  • Microsoft SQL Server 2008 R2 Reporting Services
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • SQL Server 2012 Enterprise Core
Keywords: 
kbtshoot kbexpertiseinter kbhowto kbinfo KB956893
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support