Microsoft SQL Server - license models of SQL Server Standard edition
SQL Standard | Server + CAL/EC (No Virtualization; No Mobility)
| Relevant for | SQL Server Standard 2005 SQL Server Standard 2008 SQL Server Standard 2008 R2 SQL Server Workgroup 2005 SQL Server Workgroup 2008 SQL Server Workgroup 2008 R2 |
|---|---|
| License Entitlement | Device |
| Metric | Number of operating system environments where the software is run on the device. |
| Included Virtual Instances | 0 |
| License Mobility | No |
Example
ESX host with 4 dual-core CPUs with hyperthreading (no SQL Server installation).
Currently hosted environments:
- VM1 with 1 processor (SQL Server Installation) – enabled
- VM2 with 1 processor (SQL Server Installation) – enabled
- VM3 with 1 processor (SQL Server Installation) – enabled
- VM4 with 1 processor (SQL Server Installation) – disabled
Formerly hosted environments:
- VM5 with 1 processor (SQL Server Installation) – enabled – moved to another host 30 days ago
- VM6 with 1 processor (SQL Server Installation) – enabled – moved to another host 95 days ago
License requirement:
- Currently there are 3 enabled virtual machines on the host
+ virtual machine was run on the host 30 days ago (which is a total of 4 VMs) = 4 licenses
- Virtual machine was run on the host 95 days ago = 0 licenses (minimum license entitlement has expired)
License requirement total = 4 licenses
SQL Standard | Server + CAL/EC (No Virtualization; Mobility on SA)
| Relevant for | SQL Server Standard 2012 SQL Server Standard 2014 SQL Server Business Intelligence 2012 SQL Server Business Intelligence 2014 |
|---|---|
| License Entitlement | Device |
| Metric | Number of operating system environments where the software is run on the device. |
| Included Virtual Instances | 0 |
| License Mobility | Yes, but only if the used license is subject to Software Assurance (SA; maintenance). Otherwise no. |
Example
ESX host with 4 dual-core CPUs with hyperthreading (no SQL Server installation).
Currently hosted environments:
- VM1 with 1 processor (SQL Server Installation) – enabled
- VM2 with 1 processor (SQL Server Installation) – enabled
- VM3 with 1 processor (SQL Server Installation) – enabled
- VM4 with 1 processor (SQL Server Installation) – disabled
Formerly hosted environments:
- VM5 with 1 processor (SQL Server Installation) – enabled – moved to another host 30 days ago
- VM6 with 1 processor (SQL Server Installation) – enabled – moved to another host 95 days ago
License requirement without Software Assurance:
- Currently there are 3 enabled virtual machines on the host
+ virtual machine was run on the host 30 days ago (which is a total of 4 VMs) = 4 licenses
- Virtual machine was run on the host 95 days ago = 0 licenses (minimum license entitlement has expired)
License requirement total = 4 licenses
License requirement for licensing with Software Assurance:
- Currently there are 3 enabled virtual machines on the host = 3 licenses
- Virtual machine was run on the host 30 days ago = 0 licenses (license mobility)
- Virtual machine was run on the host 95 days ago = 0 licenses (minimum license entitlement has expired)
License requirement total = 3 licenses
SQL Standard | CPU (No Virtualization; No Mobility)
| Relevant for | SQL Server Standard 2005 SQL Server Standard 2008 |
|---|---|
| License Entitlement | Device |
| Metric |
Number of processors where the software is run on the device or on virtual machines. The number of processors is counted for physical devices, and the number of allocated processors is multiplied by the number of threads per processor for virtual machines. |
| Algorithm |
Build sum with each OS-Environment running SQL { If physical Number of CPU Else (if virtual) Number of virtual CPU / number of threads per physical CPU } |
| Included Virtual Instances | 0 |
| License Mobility | No |
Example
ESX host with 4 dual-core CPUs with hyperthreading (no SQL Server installation).
Currently hosted environments:
- VM1 with 1 processor (SQL Server Installation) – enabled
- VM2 with 1 processor (SQL Server Installation) – enabled
- VM3 with 1 processor (SQL Server Installation) – enabled
- VM4 with 1 processor (SQL Server Installation) – disabled
Formerly hosted environments:
- VM5 with 1 processor (SQL Server Installation) – enabled – moved to another host 30 days ago
- VM6 with 1 processor (SQL Server Installation) – enabled – moved to another host 95 days ago
License requirement:
- Currently there are 3 enabled virtual machines on the host = 3 x (1 CPU / 2 threads (hyperthreading; for VM rounded up to a whole number)) = 3 licenses
- Virtual machine was run on the host 30 days ago = 1 CPU / 2 threads (hyperthreading; for VM rounded up to a whole number) = 1 license
- Virtual machine was run on the host 95 days ago = 0 licenses (minimum license entitlement has expired)
License requirement total = 4 licenses
SQL Standard | CPU (No Virtualization; Mobility)
| Relevant for | SQL Server Standard 2008 R2 |
|---|---|
| License Entitlement | Device |
| Metric |
Number of processors where the software is run on the device or on virtual machines. The number of processors is counted for physical devices, and the number of allocated processors is multiplied by the number of threads per processor for virtual machines. |
| Algorithm |
Build sum with each OS-Environment running SQL { If physical Number of CPU Else (if virtual) Number of virtual CPU / number of threads per physical CPU } |
| Included Virtual Instances | 0 |
| License Mobility | Yes |
Example
ESX host with 4 dual-core CPUs with hyperthreading (no SQL Server installation).
Currently hosted environments:
- VM1 with 1 processor (SQL Server Installation) – enabled
- VM2 with 1 processor (SQL Server Installation) – enabled
- VM3 with 1 processor (SQL Server Installation) – enabled
- VM4 with 1 processor (SQL Server Installation) – disabled
Formerly hosted environments:
- VM5 with 1 processor (SQL Server Installation) – enabled – moved to another host 30 days ago
- VM6 with 1 processor (SQL Server Installation) – enabled – moved to another host 95 days ago
License requirement:
- Currently there are 3 enabled virtual machines on the host = 3 x (1 CPU / 2 threads (hyperthreading; for VM rounded up to a whole number)) = 3 licenses
- Virtual machine was run on the host 30 days ago = 0 licenses (license mobility)
- Virtual machine was run on the host 95 days ago = 0 licenses (minimum license entitlement has expired)
License requirement total = 3 licenses
SQL Standard | Core (No Virtualization; Mobility)
| Relevant for | SQL Server Standard 2012 |
|---|---|
| License Entitlement | Device |
| Metric |
Number of processors where the software is run on the device or on virtual machines. Processor cores are counted and multiplied by the relevant factor for physical devices. Allocated processors are counted and multiplied by the number of threads per physical processor for virtual machines - a minimum count of 4 cores per virtual machine applies. |
| Algorithm |
Build sum with each OS-Environment running SQL { If physical Number of cores * core factor Else (if virtual) Max(Number of virtual CPU * number of threads per physical core,4) } |
| Included Virtual Instances | 0 |
| License Mobility | Yes |
| Valid Until | December 2013 |
Example
ESX host with 4 dual-core CPUs with hyperthreading (no SQL Server installation).
Currently hosted environments:
- VM1 with 1 processor (SQL Server Installation) – enabled
- VM2 with 1 processor (SQL Server Installation) – enabled
- VM3 with 1 processor (SQL Server Installation) – enabled
- VM4 with 1 processor (SQL Server Installation) – disabled
Formerly hosted environments:
- VM5 with 1 processor (SQL Server Installation) – enabled – moved to another host 30 days ago
- VM6 with 1 processor (SQL Server Installation) – enabled – moved to another host 95 days ago
License requirement:
- Currently there are 3 enabled virtual machines on the host = 3 x (1 CPU * 2 threads (hyperthreading)) = 12 licenses (at least 4 licenses per virtual machine)
- Virtual machine was run on the host 30 days ago = 0 licenses (license mobility)
- Virtual machine was run on the host 95 days ago = 0 licenses (minimum license entitlement has expired)
License requirement total = 12 licenses
SQL Standard | Core (No Virtualization; Mobility on SA)
| Relevant for | SQL Server Standard 2012 SQL Server Standard 2014 |
|---|---|
| License Entitlement | Device |
| Metric |
Number of processor cores where the software is run on the device or on virtual machines. Processor cores are counted and multiplied by the relevant factor for physical devices. Allocated processors are counted and multiplied by the number of threads per physical processor for virtual machines - a minimum count of 4 cores per virtual machine applies. |
| Algorithm |
Build sum with each OS-Environment running SQL { If physical Number of cores * core factor Else (if virtual) Max(Number of virtual CPU * number of threads per physical core,4) } |
| Included Virtual Instances | 0 |
| License Mobility | Yes, but only if the used license is subject to Software Assurance (SA; maintenance). Otherwise no. |
Example
ESX host with 4 dual-core CPUs with hyperthreading (no SQL Server installation).
Currently hosted environments:
- VM1 with 1 processor (SQL Server Installation) – enabled
- VM2 with 1 processor (SQL Server Installation) – enabled
- VM3 with 1 processor (SQL Server Installation) – enabled
- VM4 with 1 processor (SQL Server Installation) – disabled
Formerly hosted environments:
- VM5 with 1 processor (SQL Server Installation) – enabled – moved to another host 30 days ago
- VM6 with 1 processor (SQL Server Installation) – enabled – moved to another host 95 days ago
License requirement:
- Currently there are 3 enabled virtual machines on the host = 3 x (1 CPU / 2 threads (hyperthreading; for VM rounded up to a whole number)) = 12 licenses (at least 4 licenses per virtual machine)
- Virtual machine was run on the host 30 days ago = 1 CPU / 2 threads (hyperthreading; for VM rounded up to a whole number) = 4 licenses (at least 4 licenses per virtual machine)
- Virtual machine was run on the host 95 days ago = 0 licenses (minimum license entitlement has expired)
License requirement total = 16 licenses
License requirement for licensing with Software Assurance:
- Currently there are 3 enabled virtual machines on the host = 3 x (1 CPU / 2 threads) = 12 licenses
- Virtual machine was run on the host 30 days ago = 0 licenses (license mobility)
- Virtual machine was run on the host 95 days ago = 0 licenses (minimum license entitlement has expired)
License requirement total = 12 licenses
SQL Standard | Core (SPLA; No Virtualization; Mobility)
| Relevant for | SQL Server Standard 2012 SQL Server Standard 2014 |
|---|---|
| License Entitlement | Device |
| Metric |
Number of processor cores where the software is run on the device or on virtual machines. Processor cores are counted and multiplied by the relevant factor for physical devices. Allocated processors are counted and multiplied by the number of threads per physical processor for virtual machines - a minimum count of 4 cores per virtual machine applies. |
| Algorithm |
Build sum with each OS-Environment running SQL { If physical Number of cores * core factor Else (if virtual) Max(Number of virtual CPU * number of threads per physical core,4) } |
| Included Virtual Instances | 0 |
| License Mobility | Yes |
Example
ESX host with 4 dual-core CPUs with hyperthreading (no SQL Server installation).
Currently hosted environments:
- VM1 with 1 processor (SQL Server Installation) – enabled
- VM2 with 1 processor (SQL Server Installation) – enabled
- VM3 with 1 processor (SQL Server Installation) – enabled
- VM4 with 1 processor (SQL Server Installation) – disabled
Formerly hosted environments:
- VM5 with 1 processor (SQL Server Installation) – enabled – moved to another host 30 days ago
- VM6 with 1 processor (SQL Server Installation) – enabled – moved to another host 95 days ago
License requirement:
- Currently there are 3 enabled virtual machines on the host = 3 x (1 CPU / 2 threads (hyperthreading; for VM rounded up to a whole number)) = 12 licenses (at least 4 licenses per virtual machine)
- Virtual machine was run on the host 30 days ago = 0 licenses (license mobility)
- Virtual machine was run on the host 95 days ago = 0 licenses (minimum license entitlement has expired)
License requirement total = 12 licenses