Skip to main content
Matrix42 Self-Service Help Center

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