So a few weeks back I said that SQL Server 2008 R2 would have a new edition, with a new edition comes a revamp in the overall licensing
Couple of basic points before we begin, as a few emails have come through on this and a little bit of confusion
Note 1: SQL Server Standard and Enterprise 2008 R2 can be licensed in either Server/CAL mode or Per Processor mode your choice
Note 2: SQL Server Datacenter is offered in Per Processor mode only
I know that sometimes its easy to confuse license rights for the different modes, so let me cover that below, by mode/edition, then next post will concentrate on migration/transition for SA customers and next steps…..
In a nutshell
SQL Server 2008 R2 Datacenter is licensed Per Proc only, count and license all the physical procs in box = unlimited number of running instance of SQL Datacentre in any number of OS environments = unlimited virtualization, you also have the ability to move these instances in accordance with Server Application Mobility rights – discussed in a previous blog post and you can run Standard or Enterprise in place of DC in any OSE
SQL Server 2008 R2 Enterprise is licensed Per Proc or Per Server/CALs, Server Application Mobility Rights exist and are outlined in the PUR, you can run an instance of Standard in place of Enteprise in any of the OSEs – Yippeeeee!!!
SQL Server 2008 R2 Standard is licensed Per Proc or Per Server/CALs, currently no Server Application Mobility Rights
Now to the official – Info from the PUR below
SQL Server 2008 R2 Datacenter– Licensed in Per Processor Mode – License ALL Physical Procs
You must count and license all of the physical processors
You may run the server software in one physical and any number of virtual operating system environments without regard to the number of physical and virtual processors used.
You may run on the licensed server instances of Enterprise or Standard in place of Datacenter in any of the operating system environments.
SQL Server 2008 R2 Enterprise – Licensed in Per Processor Mode – 2 choices on counting licenses
If you 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
If you don’t want to license all the physical procs in the box, you can license on procs used, as below, to provide you proc count for Enterprise edition, remember for Standard or WG or Small business your only option is “procs used”
Under this option, the total number of software licenses required for a server equals the sum of the software licenses required under (A) and (B) below.
(A) 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.
(B) To run instances of the server software in virtual operating system environments on a server, you need a software license for each virtual processor1 that each of those virtual operating system environments uses. If a virtual operating system environment uses a fraction of a virtual processor, the fraction counts as a full virtual processor.
I covered a long time ago the counting process for SQL, this info is now in the April PUR, as below
A virtual processor is a processor in a virtual (or otherwise emulated) hardware system.
Virtual operating system environments use virtual processors.
Solely for licensing purposes, a virtual processor is considered to have the same number of threads and cores as each physical processor on the underlying physical hardware system. So, for any given virtual operating system environment on a server on which each physical processor provides X logical processors, the number of licenses required is the sum of a) and b) below:
a) one license for every X logical processors that virtual operating system environment uses
b) one license if the number of logical processors it uses is not a whole number multiple of X
“X,” as used above, equals the number of cores, or where relevant, the number of threads in each physical processor.
SQL Server 2008 R2 Enterprise – Licensed in Server/CAL Mode
You have the following right for each server to which you assign a software license.
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 may 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 – Licensed in Per Proc Mode – Based on Procs used as above
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
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.
Don’t forget, Fail-over rights still exist and have been extended from 2000 to now include Small Business, Workgroup and Standard
Enterprise has had fail-over rights for a long time
For SQL Server 2008 Small Business*, SQL Server 2008 R2 Enterprise, SQL Server 2008 R2 Standard* and SQL Server 2008 R2 Workgroup*:
Fail-over Rights. For any operating system environment 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 operating system environment for temporary support. You may run the passive fail-over instances on a server other than the licensed server.
Note: SQL Datacentre is only available for servers with two or more processors, Customers may not run instances of the server software on a server with less than two processors
Note: You may not enroll more than 25 instances of any version or edition of SQL Server software with the Control Point Utility in the server software at any one time