WintelGuy.com
MS SQL 2016/2017 Ent Licensing Calculator (unofficial)

This tool helps determine the number and estimate the cost of MS SQL Server Enterprise Edition licenses for a virtualized environment.

Host specification:

# of hosts:
CPUs per host:
Cores per CPU:
Required # of VMs running SQL:
Number of vCPUs per VM:
Enterprise Edition
2-core pack cost:
SA included:

Licensing method: per physical core per VM
# of cores or vCPUs to be licensed:1620
# of VMs to be licensed:55
Required # of core licenses:1620
Required # of 2-core packs:810
# of licensed VMs:165
Total cost:114048142560

Inputs:

Host specification - since the MS SQL Server 2016/2017 Enterprise licensing model is core-based, this tool requires information about the number of servers/hosts, the number of CPUs per server, and the number of cores per CPU.

Required # of VMs running SQL - the total number of VMs running MS SQL Server Server Enterprise edition software.

This tool takes into account the following conditions and limitations:

  • When licensing a physical server, all physical cores on the server must be licensed and a minimum of four core licenses are required for each physical processor on the server.
  • When all physical cores on the server are licensed, the maximum number of VMs running MS SQL is equal to the number of core licenses assigned to the server. Additional core licenses can be assigned to the licensed server if more VMs are required. Each additional core license allows deployment of SQL Server software in an additional VM.
  • When all physical cores on the server are licensed and covered by active Software Assurance, there is no limit to the number of SQL instances or the number of VMs running MS SQL.
  • To license individual VMs using Per Core model, a core license is required for each v-core (or virtual processor, virtual CPU, virtual thread) allocated to the VM, subject to a four core license minimum per VM.
  • Any of the virtual cores in a VM is mapped only to one hardware thread.
  • Core licenses are sold in packs of two (two-core packs).

This tool does not cover:

  • Server+CAL licensing option for MS SQL Server Enterprise Edition.
  • any high availability, fail-over, or cloud deployment scenarios.
  • any Database Engine or OS compute capacity limits (maximum number of CPUs, cores, etc.).

The default values used by this tool are for illustration purpose only. Please adjust as required.