Skip to main content
Matrix42 Self-Service Help Center

Microsoft SQL Server - license model of SQL Server Datacenter edition

SQL Datacenter | CPU (Full Virtualization; Mobility)

Relevant for SQL Server Datacenter 2008 R2
License Entitlement Device
Metric

Number of processors where the software is run on the device or on virtual machines.

At least two, and maximum number is the number of physical processors.

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

Max(

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

}

),2)

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 = 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

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 = 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)

  • Was this article helpful?