There is no end of confusion on Microsoft SQL licensing when it comes to Virtualization. After the break, a quick reference guide to make sure your on the right track.
SQL Server Datacenter
Licensed on a Per Processor model:
- Count and license all the physical Procs in a box
- Obtain unlimited # of running instance of SQL Datacenter in an unlimited # of OS environments.
- SQL has Server Mobility Rights. Check the Microsoft White Paper
- Down Edition Rights Check my previous blog post
SQL Server Enterprise
A) Licensing All Physical Processors
If you license all of the physical processors on the server (one license per physical processor), you may run unlimited
instances of the SQL Server software in 4 OSEs (either physical or virtual):
- Count all the Physical Procs in the box
- You may run unlimited # instances in up to four operating systems environments for each Enterprise license you assign to the server.
- Down Edition Rights apply to those Instances.
Alternative to a Physical Processor count – look at the Procs Used:
B) Licensing a Portion of the Physical Processors
If you choose not to license all of the physical processors, you will need to know the number of virtual processors
supporting each virtual OSE and the number of cores per physical processor/socket. Typically,
each virtual processor is the equivalent of one core:
- / # of cores (hyper-threading
- / # threads (if hyper-threading on) per
SQL Server Standard Edition
- If you license on the physical processors you may run the software in the physical OSE only.
- If you license all of the physical processors on the server (one license per physical processor), you may run unlimited
instances of the SQL Server software in 1 Physical OSE.
- In order to run the software in Virtual OSEs, you will need to license the number of virtual processors supporting each virtual OSE (See above)
- 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 (1:1)
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. The number of physical and virtual processors used in that separate operating system environment must not exceed the number of physical and virtual processors used in the corresponding operating system environment in which the active instances are running. You may run the passive fail-over instances on a server other than the licensed server.
Product Use Rights, July 2010, Page 62 of 136
Down Edition Rights
- New “down edition” rights are being introduced for SQL Server 2008 R2
- Customers who purchased a higher edition of SQL Server have rights to use a lower edition, but the Product Use rights of the higher edition will prevail. Product Use Rights, July 2010
- A SQL Server CAL and Windows Server CAL are required for each device or user that is connected to the
multiplexing or pooling software or hardware front end.
- The number of tiers of hardware or software between the SQL Server and the user or devices that ultimately use its data, services, or functionality does not affect the number of CALs required
- Check the Microsoft Licensing Brief
- You may move running instances of SQL Server 2008 R2 Enterprise or Datacenter as needed across servers within a server farm. (There is no 90 day minimum period before reassignment.)
- Check the Microsoft White Paper