The ultimate guide to Microsoft SQL Server licensing
Microsoft’s grant program for SQL licensing expires on April 1, 2015. If you haven’t taken advantage of the grant’s offer of free per-core licensing, it’s time to determine if you’re eligible and act.
This offer and deadline are just one piece of a larger update to the way organizations license Microsoft SQL Server. While the new rules were enacted with the release of SQL Server 2012, many organizations are still trying to understand what these changes mean for them.
To help you better understand these agreements, we’ve written a primer explaining the main ways SQL is licensed, and the many other factors you have to consider when determining your licensing requirements.
A shift to per-core licensing
Microsoft adjusted its SQL licensing rules when it released SQL Server 2012, and these updates are reflected in the three main editions of SQL Server — Enterprise, Business Intelligence (BI), and Standard. At the same time, Microsoft did away with the processor license model that reigned for years and paved the way for per-core licensing.
There are still two ways to license SQL Server: the Server/CAL model and core-based licensing. The Server/CAL model is still alive and well, but Microsoft removed Enterprise as an option from this model. They did “replace” that edition with SQL Server BI, but the drawback is that SQL BI is only available in the Server/CAL model.
What this means for customers across the globe is that moving forward, the only way to license SQL Enterprise is to purchase cores. While Enterprise is core only and BI is Server/CAL only, the good news is that Standard is available in both Server/CAL and core based.
How these changes affect virtualization rights
Organizations licensed through the Server/CAL and Standard Core licensing models must license each virtual machine (VM) individually. Organizations that have SQL Standard with core-based licensing are required to license four cores per VM, at the minimum.
With Enterprise, it gets a little tricky. Organizations have the option to license all physical cores to get unlimited VM rights with SQL, but in order to have this right, they must have active Software Assurance (SA), and the right is only good while the SA is active.
If there is no active SA attached to SQL Enterprise, and all physical cores are licensed, then organizations can run SQL in a number of VMs equal to the number of physical cores.
What about License Mobility?
License Mobility is an SA benefit that allows SQL to migrate from host to host as needed, without the typical 90 day rule, and can be applied either of two ways.
Licensing individual VMs with SA allows the use of License Mobility with each of those licenses. The only way to get License Mobility when all physical cores are licensed with SA is to license more than one host. In other words, organizations can either license individual VMs and move them around as needed, or license multiple hosts with Enterprise Core with SA and only have SQL running on those hosts.
There’s always a breakeven point between the number of VMs, hosts, and cores all predicated on which version of SQL needs to be running. But remember that moving SQL through VMs requires Windows Server to be licensed as Windows Server Datacenter.
Datacenter allows for unlimited OSs per licensed host, but doesn’t have mobility rights. Mobility rights are bypassed because organizations can run any number of VMs and it doesn’t matter where the VM sits as long as each host is licensed with Windows Server Datacenter.
What the changes mean for SA renewals, other restrictions
For organizations with locked in pricing on an Enterprise Agreement (EA) for SQL Enterprise Server/CAL, the license can be renewed as SA only, but organizations can’t purchase new licenses after the third-year true up and the renewal is processed. Organizations have the right to install SQL Enterprise 2012 and 2014, but because this edition is end-of-life, Microsoft has placed a 20-core limit hardcoded in the software when you upgrade from Windows Server 2008 R2. This is per physical host, and thus prevents the stacking of licenses to get more core usage. These changes will affect most customers on the physical side, and will create a natural need to migrate to core-based Enterprise.
In the SQL Server Core model, both Standard and Enterprise have a minimum consumption rate of four cores, either per physical processor or per VM. While this will rarely affect users on the physical front, it will impact the virtual world. Organizations with less than four cores assigned to a VM still must assign those four cores to that VM.
For customers renewing SA from the processor model, Microsoft is providing four free cores per license. But what if an organization has more than four cores per processor license? This is where the Microsoft Assessment and Planning (MAP) Toolkit comes into play; by scanning the IT environment, MAP provides the details of each SQL install. By using MAP, organizations reduce the risk of an audit. While there’s no guarantees customers will avoid an audit, having and keeping open dialogue with Microsoft is the best prevention.
Licensing SQL can be difficult to understand, and the process for renewing SA with SQL can be arduous at best, so it’s always better to start the process early and get ahead of the curve. Talk to your SHI Account Executive to get the help you need to demystify SQL licensing.