New SQL 2. 01. 2 Licensing and Its Impact On Virtualization « The Lowercase w. Last week Microsoft released their updated licensing scheme for SQL Server 2. Though there are a number of changes to the product and to how it is licensed, in my mind the biggest change is that Microsoft has moved to a per core licensing model for SQL. The Server + CAL model still exists as well but for this post I’ll focus on the per core licensing and changes that affect those that want to virtualize SQL Server 2. You can read more about the new licensing for SQL 2. SQL 2. 01. 2 Licensing Overview page. Here are some of the highlights: The Datacenter Edition from SQL 2.
R2, which was previously licensed per socket/CPU, has been discontinued. The top tier license is now Enterprise Edition (EE), which is licensed per core. It requires a minimum of 4 core licenses per processor. If all cores in a host are licensed, you retain the unlimited virtualization rights previously available in SQL 2. R2 Datacenter Edition. The cost per core of SQL 2.
Enterprise will be $6,8. Software Assurance (SA). Software Assurance is required in order to use license mobility (i. Motion/Live Migration) more than once every 9. Instead of licensing an entire server, you can also license the virtual cores of individual SQL virtual machines. Core licenses are sold in 2 core packs.
This document explains key licensing considerations for SQL Server 2008 customers. SQL Server 2008 SeRver. PLUS. CAL Licensing. Http:// SQL Server 2008 licensing overview. NOTE :このエントリーは、Andrew FryerさんのBlogに投稿された「 SQL Server 2008 Filestream FAQs 」をAndrewさんの許可を頂いて意訳して. Check this document: 2008 SQL Licensing Overview Final.docx In short: you've got 2 options: 1) Buy 1 SQL server 2008 Server license + CAL licenses (Quote. 2008 SQL Licensing Overview final.docx. Date Published: 7/31/2008. File Size: 451 KB. SQL Server 2008 Pricing and Licensing System Requirements..
There is a limitation of 2. EE. (Note: this has been clarified - see below)If you are current on SA and have SQL 2. R2 Enterprise you will receive a minimum of four SQL 2.
New SQL 2012 Licensing and Its Impact On Virtualization. SQL 2008 that used the per CPU licensing. Server_2012_Licensing_Datasheet_and_FAQ_Mar2012.docx. Support for SQL 2008 Filestream Data. Backup Exec 12.5 for Windows Servers Microsoft SQL Server Protection. BE125_SQL_SolutionBrief_Dec08_final.docx. SQL Server LicenSing guide introduction i Introduction Overview This guide is for Microsoft customers who need to understand how Microsoft® SQL Server® is licensed. From the doc '2008 SQL Licensing Overview final.docx': 'A SQL Server User CAL is required in order for a user (employee, customer, partner, and so on) to access or.
EE core licenses per CPU or the actual number of cores in use. If you are current on SA and have SQL 2.
R2 Datacenter you will receive a minimum of eight SQL 2. EE core licenses per CPU or the actual number of cores in use. Per Core Licensing. It really shouldn’t come as a surprise to anyone that Microsoft is moving from a per socket/processor model to a per- core model for licensing SQL Server. After all, processors are shipping with more and more cores per CPU and are capable of higher consolidation ratios. Combine that with the fact that the majority of SQL Server workloads are actually very light use (based on VMware Capacity Planner data) and you can see that Microsoft couldn’t continue with per socket licensing. The only potential issue I see is the minimum of 4 cores licenses per processor. If organizations are still using older hardware that only has 2 cores/processor then they are paying for cores they don’t have. I would suspect that in 2.
Update 1. 1/1. 9/2. Microsoft has included a core multiplication factor that will account for older systems that have fewer than 4 cores per processor. Cost. The actual cost for EE is roughly the same as if you licensed 2 sockets of SQL 2. R2 Enterprise Edition as long as it had 4 cores per CPU. The cost goes up as soon as you start using 6 core processors and above. The prevalence of 4 core processors means this likely won’t change much for many organizations. Compared to SQL 2. R2 Datacenter, however, there is a large cost difference. Datacenter costs $5.
CPU system. You can now essentially get the benefits of Datacenter Edition (unlimited virtualization rights, etc.) for half the cost you would pay in SQL 2. R2. Even with this new licensing model there are still huge cost savings to be had by licensing all cores of a server and virtualizing your SQL 2. It’s hard to argue with unlimited virtualization rights especially for those lightly loaded SQL workloads. There may be situations where Server + CAL licensing actually makes more sense. If you’re worried about the higher per core costs that may be something to consider. Server + CAL licensing requires a lot more administrative overhead and is usually only beneficial for situations where there are a small amount of users/devices that are easily accounted for. Licensing per VMInstead of licensing all of the cores in a server, you can instead simply license the cores you use in your SQL virtual machines. Sounds easy, right? Unfortunately you are still required to license four cores per VM. Since the majority of SQL workloads are underutilized and can likely get by with 1- 2 v.
CPUs, you’re essentially paying for core licenses you won’t use. I can’t imagine many organizations will go down this road unless they have a small number of larger SQL servers. Update 1. 1/1. 9/2. Another aspect of per VM licensing that may be undesirable is the requirement to purchase extra licenses if you use Intel processors with hyper- threading enabled. See this post for more details.
Core Limitation. I have to admit I’m scratching my head a bit on this one. Knowing that 1. What happens if you already own 1. The only thing the SQL 2. Licensing Guide says is to “contact your Microsoft representative for help transitioning to the new licensing model.” It’s not uncommon for organizations to scale up and have ESX/ESXi hosts with greater than 2. I would hope there is a reasonable solution here.
Update 1. 2/1. 9/2. On December 1st, Microsoft released an updated copy of their licensing datasheet for SQL 2. In this updated version, they clarify the language around the 2. SQL 2. 01. 2 EE licenses that were upgraded from SQL 2. Server + CAL model. For EE licenses that are purchased new, or that were upgraded from SQL 2. CPU licensing model, you are not limited to just 2. See this post for more information.
Software Assurance. If you already have SA on your SQL 2. R2 licenses, you’re probably in better shape than you think. Note the italics above regarding “actual number of cores in use.” If you use per processor licensing in SQL now and your processors have more than 4/8 cores, work with Microsoft to get core licenses for what you’re actually using rather than simply accepting the default trade- in value. Those that bought into higher core CPUs should not be penalized by upgrading to SQL 2. Software Assurance also gives you the right to full virtual machine mobility. In other words, the rights to use v. Motion/DRS in v. Sphere to move your SQL workloads more than once per 9. You still need the appropriate Windows license to allow that mobility, but again this is another reason why Software Assurance is becoming mandatory. Final Thoughts. Anyone still reading? I realize this is a large post so I’ll keep my final thoughts brief. In short, I think that the move to per- core based licensing was an inevitable change that I would expect to see other vendors take up as well. The bright side is that the cost to have unlimited virtualization rights for SQL has essentially been cut in half depending on whether or not you already owned the SQL 2.
Datacenter license. Anything that promotes the virtualization of mission critical applications like SQL is good in my book. I look forward to talking to customers about this change and helping them move towards virtualizing their SQL deployments.