Skip to main content
Matrix42 Self-Service Help Center

Microsoft SQL Server - License models provided by LIS

Introduction

This is the list of license models provided by LIS for Microsoft SQL Server as of December 2020.

The name of the license model refers to the product version with which the implemented metric was published by Microsoft in their product use rights / product terms documentation. 

Example: The license models "SQL Standard 2016..." were introduced with that version but apply also for SQL Server 2019.

Standard Edition

Name of License Model Description
SQL Standard 2005 | CPU (No Virtualization; No Mobility) One license for each physical or virtual processor from operating system environments running the software. Virtual processors take hyperthreading from physical processors into account.
SQL Standard 2005 | Server + CAL/EC (No Virtualization; No Mobility) One license per operating system environment running the software including virtual machines hosted now or during minimum entitlement period.
SQL Standard 2008 R2 | CPU (No Virtualization; Mobility) One license for each physical or virtual processor from operating system environments running the software. Virtual processors take hyperthreading from physical processors into account.
SQL Standard 2008 R2 | Server + CAL/EC (No Virtualization; No Mobility) One license per operating system environment running the software including virtual machines hosted now or during minimum entitlement period.
SQL Standard 2012 | Core (No Virtualization; Mobility on SA) One license per core used by all operating systems running the software. Core factor applies to physical processors while virtual processors take hyperthreading of physical cpu into account.
SQL Standard 2012 | Core (No Virtualization; Mobility) One license per core used by all operating system environments running the software on the device now or during minimum entitlement period.   Core factor applies to physical processors while virtual processors take hyperthreading of physical processors into account with a minimum of 4 virtual cores.
SQL Standard 2012 | Core (SPLA; No Virtualization; Mobility) One license per core used by all operating systems running the software. Core factor applies to physical processors while virtual processors take hyperthreading of physical cpu into account.
SQL Standard 2012 | Server + CAL/EC (No Virtualization; Mobility on SA) One license per operating system environment running the software including virtual machines hosted now or during minimum entitlement period.  Software Assurance limits licensing to current hosts only (license mobility).
SQL Standard 2016 | Core (No Virtualization; Mobility on SA) Number of processor cores of physical machine where the software is installed. At least 4 cores have to be licensed per CPU.  Number of logical processors assigned to the virtual machines where the software is installed. At least 4 processors have to be licensed per virtual machine.
SQL Standard 2016 | Core (SPLA; No Virtualization ; Mobility) Number of processor cores of physical machine where the software is installed. At least 4 cores have to be licensed per CPU.  Number of logical processors assigned to the virtual machines where the software is installed. At least 4 processors have to be licensed per virtual machine.

Enterprise Edition

Name of License Model Description
SQL Enterprise 2005 | CPU (Full Virtualization; No Mobility) One license for each physical or virtual processor from operating system environments running the software during minimum entitlement period. Virtual processors take hyperthreading from physical processors into account. If all physical processors are licensed all virtual instances hosted on the hardware are also entitled.
SQL Enterprise 2005 | CPU (SPLA; No Virtualization; No Mobility) One license for each physical or virtual processor from operating system environments running the software. Virtual processors take hyperthreading from physical processors into account.
SQL Enterprise 2005 | Server + CAL/EC (Full Virtualization; No Mobility) One license per server with unlimited virtualization considering minimum entitlement period.
SQL Enterprise 2008 | CPU (Full Virtualization; Mobility) One license for each physical or virtual processor from operating system environments running the software during minimum entitlement period.   Virtual processors take hyperthreading from physical processors into account. If all physical processors are licensed all virtual instances hosted on the hardware are also entitled.
SQL Enterprise 2008 | CPU (SPLA; Full Virtualization; No Mobility) One license for each physical or virtual processor from operating system environments running the software. Virtual processors take hyperthreading from physical processors into account. If all physical processors are licensed all virtual instances hosted on the hardware are also entitled.
SQL Enterprise 2008 | Server + CAL/EC (Full Virtualization; Mobility) One license per server with unlimited virtualization
SQL Enterprise 2008 R2 | CPU (Ltd. Virtualization; Mobility) One license for each physical processor or each 4 operating system environments running the software. Alternatively one license for each logical processor of each operating system environment running the software where virtual processors take hyperthreading from physical processors into account.
SQL Enterprise 2008 R2 | CPU (SPLA; Ltd. Virtualization; Mobility) One license for each physical processor or each 4 operating system environments running the software. Alternatively one license for each logical processor of each operating system environment running the software where virtual processors take hyperthreading from physical processors into account.
SQL Enterprise 2008 R2 | Server + CAL/EC (Ltd. Virtualization; Mobility) One license per four operating system environments running the software.
SQL Enterprise 2012 | Core (Full Virtualization on SA; Mobility on SA) One license for each physical core with core factor applied or virtual core in each operating system environment running the software. Virtual environments require a minimum of four core licenses. While every license includes one virtual operating system environment running the software every additional virtual operating system running the software requires one additional license. SA entitles for unlimited virtual instances running the software.
SQL Enterprise 2012 | Core (SPLA; Full Virtualization; Mobility) One license for each physical core with core factor applied or every logical core in each operating system environment running the software. Virtual environments require a minimum of four core licenses. When all physical cores are licensed number of virtual operating systems running the software is unlimited. This license model applies to SPLA only.
SQL Enterprise 2012 | Server + CAL/EC (Ltd. Virtualization; Mobility on SA) One license per 4 operating system environments running the software including virtual machines hosted now or during minimum entitlement period.  Software Assurance limits licensing to current hosts only (license mobility).
SQL Enterprise 2016 | Core (Full Virtualization on SA; Mobility on SA) Amount of processor cores of operating system environment where software is running. In virtual machines a total minimum of four cores applies. With every license for a physical core one virtual instance is included. With Software Assurance the number of virtual instances is unlimited and license mobility is granted.
SQL Enterprise 2016 | Core (SPLA; Full Virtualization; Mobility) Amount of processor cores of operating system environment where software is running. In virtual machines a total minimum of four cores applies. With every license for a physical core one virtual instance is included. With Software Assurance the number of virtual instances is unlimited and license mobility is granted.

Datacenter Edition

Name of License Model Description
SQL Datacenter 2008 R2 | CPU (Full Virtualization; Mobility) One license for each physical or virtual processor from operating system environments running the software. Virtual processors take hyperthreading from physical processors into account. If all physical processors are licensed all virtual instances hosted on the hardware are also entitled. There is a minimum of two licenses required per device.