Fail-over Servers. For any OSE in which you run instances of the server software, you may run up to the same number of passive fail-over instances in a separate OSE for temporary support. The number of physical and virtual processors used in that separate OSE must not exceed the number of physical and virtual processors used in the corresponding OSE in which the active instances are running. You may run the passive fail-over instances on a server other than the licensed server.

 

The licensing requirements for SQL Server® 2008 R2 in a virtual environment differ with the various editions of SQL Server®.

 

SQL Server® 2008 R2 Datacenter Edition

 

The Datacenter Edition is only available as Per Processor.

  • You need to count and license all physical processors regardless of the number of SQL Server® instances or number of Virtual Instances.
  • You may run the server software in one physical and any number of virtual operating system environments without regard to the number of virtual processors used.
  • You may also run server instances of Enterprise or Standard in place of Datacenter in any of the operating system environments.

 

SQL Server® 2008 R2 Enterprise Edition

 

With the Enterprise Edition, you have 3 options for licensing in a virtual environment:

 

Option 1: License all of the physical processors on the licensed server

  • You may run any number of instances in up to four operating systems environments for each Enterprise license you assign to the server.
  • You may run on the licensed server instances of Standard in place of Enterprise in any of these operating system environments

 

Option 2: License the processors used

There are times when it would work out cheaper only licensing the processors you are going to be using for the SQL Server® environment. If this is the case, the total number of licenses required would be a combination of:

 

  1. To run instances of the server software in the physical operating system environment on a server, you need a software license for each physical processor that the physical operating system environment uses.
  2. To run instances of the server software in virtual operating system environments on a server, you need a software license for each virtual processor that each of those virtual operating system environments uses.
  • You may run on the licensed server instances of Standard in place of Enterprise in any of these operating system environments

 

Option 3: SQL Server® 2008 R2 Enterprise – Licensed in Server/CAL Mode

There are also times when a Server/CAL option is financially viable. Under these conditions, you may run, at any one time, any number of instances of the server software in up to four operating system environments (physical or virtual) on that server.

 

You can run on the licensed server an instance of Standard in place of Enterprise in any of these operating system environments.

SQL Server® 2008 R2 Standard

 

With the Standard Edition, you have 2 options for licensing in a virtual environment:

Option 1: Licensed in Per Processor Mode

  • You may run, at any one time, any number of instances of the server software in physical and virtual operating system environments on the licensed server.
  • However, the total number of physical and virtual processors used by those operating system environments cannot exceed the number of software licenses assigned to that server.
  • Typically 1 Core = 1 Virtual processor.

 

It is important to compare the costing between the Standard Edition where the virtual licensing is per core used versus the Enterprise Edition where you are able to license Physical processors.
 

Option 2: SQL Server® 2008 R2 Standard or Workgroup – Licensed in Server/CAL Mode

For each server software license you assign, you may run any number of instances of the server software in one physical or virtual operating system environment on the licensed server at a time.

 

For more information on licensing SQL Server® 2008 R2 in a virtual environment, refer to the following document:

http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx

Nov 2016