Microsoft SQL Server - license models of SQL Server Enterprise edition
SQL Enterprise | Server + CAL/EC (Full Virtualization; No Mobility)
| Relevant for | SQL Server Enterprise 2005 |
|---|---|
| License Entitlement | Device |
| Metric | One license per physical server |
| Included Virtual Instances | Unlimited |
| 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 = 1 license (unlimited virtualization)
- Virtual machine was run on the host 95 days ago = 0 licenses (minimum license entitlement has expired)
License requirement total = 1 license
SQL Enterprise | Server + CAL/EC (Ltd. Virtualization; Mobility)
| Relevant for | SQL Server Enterprise 2008 |
|---|---|
| License Entitlement | Device |
| Metric | One license per physical server |
| Included Virtual Instances | Unlimited |
| 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 = 1 license (unlimited virtualization)
- 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 = 1 license
SQL Enterprise | Server + CAL/EC (Ltd. Virtualization; Mobility)
| Relevant for | SQL Server Enterprise 2008 R2 |
|---|---|
| License Entitlement | Device |
| Metric | One license per physical server and four virtual machines where the software is run. |
| Included Virtual Instances | 4 |
| 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 = 1 license (four virtual machines per license included)
- 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 = 1 license
Environments hosted additionally later:
- VM7 with 1 processor (SQL Server Installation) – enabled
- VM8 with 1 processor (SQL Server Installation) – enabled
License requirement:
- Currently there are 5 enabled virtual machines on the host = 2 licenses (four virtual machines per license included)
- 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 = 2 licenses
SQL Enterprise | Server + CAL/EC (Ltd. Virtualization; Mobility on SA)
| Relevant for | SQL Server Enterprise 2012 SQL Server Enterprise 2014 |
|---|---|
| License Entitlement | Device |
| Metric | One license per physical server and four virtual machines where the software is run. |
| Included Virtual Instances | 4 |
| 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
+ virtual machine was run on the host 30 days ago (a total of four VM) = 1 license (four virtual machines per license included)
- Virtual machine was run on the host 95 days ago = 0 licenses (minimum license entitlement has expired)
License requirement total = 1 license
Environments hosted additionally later:
- VM7 with 1 processor (SQL Server Installation) – enabled
License requirement:
- Currently there are 4 enabled virtual machines on the host
+ virtual machine was run on the host 30 days ago (a total of five VM) = 2 licenses (four virtual machines per license included)
- Virtual machine was run on the host 95 days ago = 0 licenses (minimum license entitlement has expired)
License requirement total = 2 licenses
License requirement for licensing with Software Assurance:
- Currently there are 4 enabled virtual machines on the host = 1 license
- 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 = 1 license
SQL Enterprise | CPU (Full Virtualization; No Mobility)
| Relevant for | SQL Server Enterprise 2005 |
|---|---|
| License Entitlement | Device |
| Metric |
Number of processors where the software is run on the device or on virtual machines. Number of physical processors is the maximum number. 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 |
Lesser of ( Number of physical CPU or 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 | Unlimited |
| License Mobility | No |
Example
ESX host with 4 dual-core CPUs with hyperthreading (no SQL Server installation).
Currently hosted environments:
- 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 not any enabled virtual machines on the host = 0 x (1 CPU / 2 threads) (hyperthreading; for VM rounded up to a whole number) = 0 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 = 1 license
Environments hosted additionally later:
- VM1 with 1 processor (SQL Server Installation) – enabled
- VM2 with 1 processor (SQL Server Installation) – enabled
- VM3 with 1 processor (SQL Server Installation) – enabled
- VM7 with 1 processor (SQL Server Installation) – enabled
- VM8 with 1 processor (SQL Server Installation) – enabled
License requirement:
- Currently there are 5 enabled virtual machines on the host = 5 x (1 CPU / 2 threads) (hyperthreading; for VM rounded up to a whole number) = 5 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)
Actual license requirement total = 6 licenses
Limited to maximum number = 4 licenses (number of physical processors)
SQL Enterprise | CPU (Full Virtualization; Mobility)
| Relevant for | SQL Server Enterprise 2008 |
|---|---|
| License Entitlement | Device |
| Metric |
Number of processors where the software is run on the device or on virtual machines. Number of physical processors is the maximum number. 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 |
Lesser of ( Number of physical CPU or 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 | Unlimited |
| License Mobility | Yes |
Example
ESX host with 4 dual-core CPUs with hyperthreading (no SQL Server installation).
Currently hosted environments:
- 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 not any enabled virtual machines on the host = 0 x (1 CPU / 2 threads) (hyperthreading; for VM rounded up to a whole number) = 0 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 = 0 licenses
Environments hosted additionally later:
- VM1 with 1 processor (SQL Server Installation) – enabled
- VM2 with 1 processor (SQL Server Installation) – enabled
- VM3 with 1 processor (SQL Server Installation) – enabled
- VM7 with 1 processor (SQL Server Installation) – enabled
- VM8 with 1 processor (SQL Server Installation) – enabled
License requirement:
- Currently there are 5 enabled virtual machines on the host = 5 x (1 CPU / 2 threads) (hyperthreading; for VM rounded up to a whole number) = 5 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)
Actual license requirement total = 5 licenses
Limited to maximum number = 4 licenses (number of physical processors)
SQL Enterprise | CPU (Ltd. Virtualization; Mobility)
| Relevant for | SQL Server Enterprise 2008 R2 |
|---|---|
| License Entitlement | Device |
| Metric |
Number of processors where the software is run on the device or on virtual machines. Four virtual machines are included for each physical processor. Maximum number is the number of physical processors or the number of virtual machines divided by four, whichever is greater. 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 |
Lesser of (Max(Number of physical CPU, Number of OS-Environment/4) or 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 | 4 |
| 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 (maximum number is the number of physical processors)
- Virtual machine was run on the host 30 days ago = 0 licenses
- Virtual machine was run on the host 95 days ago = 0 licenses (minimum license entitlement has expired)
License requirement total = 3 licenses
Later 14 more environments with 1 processor each are hosted
License requirement:
- Currently there are 17 enabled virtual machines on the host = 17 x (1 CPU / 2 threads) (hyperthreading; for VM rounded up to a whole number) = 17 licenses
- Virtual machine was run on the host 30 days ago = 0 licenses
- Virtual machine was run on the host 95 days ago = 0 licenses (license mobility)
Actual license requirement total = 17 licenses
Limited to maximum number = 5 licenses (limited to number of physical processors (4); however, virtualization number is greater: 17 VM / 4 VM per CPU = 4.25 → 5 (rounded up to a whole number)).
SQL Enterprise | Core (Full Virtualization on SA; Mobility on SA)
| Relevant for | SQL Server Enterprise 2012 SQL Server Enterprise 2014 |
|---|---|
| License Entitlement | Device |
| Metric |
Number of processors where the software is run on the device or on virtual machines. Four virtual machines are included for each physical processor. With Software Assurance, the maximum number is the total of all physical processor cores that is calculated using the Microsoft factor table. Without Software Assurance, the maximum number is the total of physical processor cores that is calculated using the Microsoft factor table or the number of virtual machines where the software is run, whichever is greater. The number of processor cores is counted and multiplied by the relevant factor for physical devices. The number of allocated processors is multiplied by the number of threads per processor for virtual machines – the minimum count of 4 cores per virtual machine applies. |
| Algorithm |
If SA: Lesser of ( physical cores * core factor or 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) } ) Else Lesser of ( Max(physical cores * core factor, Number of OSE) or 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 | 1, unlimited with SA |
| License Mobility | Yes, but only if the used license is subject to Software Assurance (SA; maintenance). Otherwise no. |
Example 1 (without Software Assurance)
ESX host with 4 dual-core CPUs with hyperthreading (no SQL Server installation) → 8 cores * factor 2.0 = 16.
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 x 2 threads (hyperthreading) = 6
+ virtual machine was run on the host 30 days ago = 1 CPU x 2 threads (hyperthreading) = 2 = 16 licenses (at least 4 cores per VM; maximum number is the core value of the physical processors (16))
- Virtual machine was run on the host 95 days ago = 0 licenses (minimum license entitlement has expired)
License requirement total = 16 licenses
Later 14 more environments with 1 processor each are hosted
License requirement:
- Currently there are 17 enabled virtual machines on the host = 17 x 1 CPU x 2 threads (hyperthreading) = 34
+ virtual machine was run on the host 30 days ago = 1 CPU x 2 threads (hyperthreading) = 2 = 18 licenses (18 VMs since it is greater than core value of the physical processors (16) and less than core value of all VMs (72; 18x4))
- Virtual machine was run on the host 95 days ago = 0 licenses (minimum license entitlement has expired)
New license requirement total = 18 licenses
Example 2 (with Software Assurance)
ESX host with 4 dual-core CPUs with hyperthreading (no SQL Server installation) → 8 cores * factor 2.0 = 16.
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 x 2 cores (hyperthreading) = 6 = 12 licenses (at least 4 cores per VM; maximum number is the core value of the physical processors (16))
- 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
Later 14 more environments with 1 processor each are hosted
License requirement:
- Currently there are 17 enabled virtual machines on the host = 17 x 1 CPU x 2 cores (hyperthreading) = 34 =16 licenses (at least 4 cores per VM; maximum number is the core value of the physical processors (16))
- Virtual machine was run on the host 30 days ago = 0 licenses
- Virtual machine was run on the host 95 days ago = 0 licenses (license mobility)
New license requirement total = 16 licenses
SQL Enterprise | CPU (SPLA; No Virtualization; No Mobility)
| Relevant for | SQL Server Enterprise 2005 |
|---|---|
| License Entitlement | Device |
| Metric |
Number of processor cores where the software is run on the device or on virtual machines. The number of processors is counted for physical devices. The number of allocated processors is multiplied by the number of threads per physical 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 (Minimum entitlement period = 30 days!) |
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)
+ 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
- Virtual machine was run on the host 95 days ago = 0 licenses (minimum license entitlement has expired)
License requirement total = 4 licenses
SQL Enterprise | CPU (SPLA; Full Virtualization; No Mobility)
| Relevant for | SQL Server Enterprise 2008 |
|---|---|
| License Entitlement | Device |
| Metric |
Number of processor cores where the software is run on the device or on virtual machines. Maximum number is the number of physical processors. The number of processors is counted for physical devices. The number of allocated processors is multiplied by the number of threads per physical processor for virtual machines. |
| Algorithm |
Lesser of ( Number of physical CPU or 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 | Unlimited |
| License Mobility | No (Minimum entitlement period = 30 days!) |
Example
ESX host with 4 dual-core CPUs with hyperthreading (no SQL Server installation).
Currently hosted environments:
- 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 not any enabled virtual machines on the host = 0 x (1 CPU / 2 threads) (hyperthreading; for VM rounded up to a whole number) = 0 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 = 1 license
Environments hosted additionally later:
- VM1 with 1 processor (SQL Server Installation) – enabled
- VM2 with 1 processor (SQL Server Installation) – enabled
- VM3 with 1 processor (SQL Server Installation) – enabled
- VM7 with 1 processor (SQL Server Installation) – enabled
- VM8 with 1 processor (SQL Server Installation) – enabled
License requirement:
- Currently there are 5 enabled virtual machines on the host = 5 x (1 CPU / 2 threads) (hyperthreading; for VM rounded up to a whole number) = 5 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)
Actual license requirement total = 6 licenses
Limited to maximum number = 4 licenses (minimum license entitlement has expired)
SQL Enterprise | CPU (SPLA; Ltd. Virtualization; Mobility)
| Relevant for | SQL Server Enterprise 2008 R2 |
|---|---|
| License Entitlement | Device |
| Metric |
Number of processors where the software is run on the device or on virtual machines. Four virtual machines are included for each physical processor. Maximum number is the number of physical processors or the number of virtual machines divided by four, whichever is greater. The number of processors is counted for physical devices. The number of allocated processors is multiplied by the number of threads per physical processor for virtual machines. |
| Algorithm |
Lesser of ( Max(Number of physical CPU, Number of OSE/4) or 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 | 4 |
| 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 (maximum number is the number of physical processors)
- 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
Later 14 more environments with 1 processor each are hosted
License requirement:
- Currently there are 17 enabled virtual machines on the host = 17 x (1 CPU / 2 threads) (hyperthreading; for VM rounded up to a whole number) = 17 licenses (17 VM / 4 = 4,25 → 5, since it is greater than number of physical processors)
- 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)
Actual license requirement total = 17 licenses
Limited to maximum number = 5 licenses (limited to number of physical processors (4); however, virtualization number is greater: 17 VM / 4 VM per CPU = 4.25 → 5 (rounded up to a whole number))
SQL Enterprise | Core (SPLA; Full Virtualization; Mobility)
| Relevant for | SQL Server Enterprise 2012 SQL Server Enterprise 2014 |
|---|---|
| License Entitlement | Device |
| Metric |
Number of processor cores where the software is run on the device or on virtual machines. Maximum number is the total of all physical processor cores that is calculated using the Microsoft factor table. The number of processor cores is counted and multiplied by the relevant factor for physical devices. The number of allocated processors is multiplied by the number of threads per physical processor for virtual machines – the minimum count of 4 cores per virtual machine applies. |
| Algorithm |
Lesser of ( physical cores * core factor or 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 | Unlimited |
| License Mobility | Yes |
Example
ESX host with 4 dual-core CPUs with hyperthreading (no SQL Server installation) → 8 cores * factor 2.0 = 16.
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 x 2 cores (hyperthreading) = 6 = 12 licenses (at least 4 cores per VM; maximum number is the core value of the physical processors (16))
- 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
Later 14 more environments with 1 processor each are hosted
License requirement:
- Currently there are 17 enabled virtual machines on the host = 17 x 1 CPU x 2 cores (hyperthreading) =34 = 16 licenses (at least 4 cores per VM; maximum number is the core value of the physical processors (16))
- 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)
New license requirement total = 16 licenses