How many SQL licenses do I need?

How many SQL licenses do I need?

You need at least four core licenses for each physical processor on the server (core licenses are sold in packs of two). The SQL Server or any of its components needs to be licensed.

What are the licensing model supported by SQL Server?

There are two main editions: Enterprise and Standard. Which other editions are available with SQL Server? Enterprise and Standard are the two main editions. The Web Edition is offered only to hosters through the Services Provider License Agreement (SPLA).

What is the difference between per core and server CAL?

Per CAL means you need a license for every user accessing SQL Server: CAL = Client Access License. Per Core means you need a license for every core of the machine where SQL Server ist running, independent of how many user access the SQL Server.

How many SQL cores do I need?

A minimum of four core licenses per physical processor are required, with licenses being sold in packs of two.

How many CPUs do I need for SQL Server?

You need 1. If you have time to wait or can’t afford more. The more cores the higher capacity. But outside free editions, with their own limitations, cpu licenses cost per core (or server+Cal lisenses).

How many CPUs can SQL use?

The Standard, Web and Express editions of SQL Server are limited to a set number of sockets or cores, whichever is smaller. On a VM, a logical CPU counts as a socket – so, for a Standard edition license, you would be limited to 4 logical CPUs.

How many processors is SQL Server using?

Standard edition: Purchase: 64 core licenses. Cores: Uses 24 cores (check that cores are allocated across all NUMA nodes)

What is per processor licensing?

Each Processor License allows an unlimited number of users to access the software that is installed on that processor for products licensed through a per processor model. Each processor in the Operating System Environment (OSE) will need a license. For e.g. Windows Server is licensed per physical processor only.

How is SQL Server 2008 R2 licensed?

SQL Server® 2008 R2 editions are licensed through Microsoft® Volume Licensing using either the Per Processor software licensing model or the Server/Client Access License (CAL) software licensing model. This brochure summarizes the editions of SQL Server 2008 R2 and the sales channels through which they are available.

How many processor licenses are required for SQL Server 2005?

For SQL Server 2005 the general rule of processor licensing requires to have one processor license for every physical and every active virtual processor. The only exception exists for SQL Server 2005 Enterprise Edition where the maximum of processor licenses required is the maximum number of physical processors of the hosting hardware.

What are the limitations of the server + CAL licensing model?

Existing Enterprise Edition licenses in the Server + CAL licensing model that are upgraded to the current version of SQL Server and beyond are limited to server deployments with 20 or fewer cores.

What is the licensing difference between Hyper-V and SQL Server Virtualization?

For both cases Windows and SQL Server there is no difference in Licensing between using Microsoft Hyper-V or a 3rd party Virtualization software like VMWare ESX. As already mentioned in the SAP OSS note, Microsoft support for Virtualization by 3rd party software is defined in KBA: http://www.support.microsoft.com/kb/897615