{"id":11890,"date":"2011-11-03T16:56:03","date_gmt":"2011-11-03T16:56:03","guid":{"rendered":"https:\/\/aidanfinn.com\/?p=11890"},"modified":"2011-11-03T16:56:03","modified_gmt":"2011-11-03T16:56:03","slug":"sql-2012-editions-licensing-announced-what-are-they-smoking","status":"publish","type":"post","link":"https:\/\/aidanfinn.com\/?p=11890","title":{"rendered":"SQL 2012 Editions &#038; Licensing Announced \u2026 What Are They Smoking?"},"content":{"rendered":"<p>Every year they promise us simplification.&#160; Let\u2019s see how they\u2019ve score this time around \u2026<\/p>\n<p>The <a href=\"http:\/\/www.microsoft.com\/sqlserver\/en\/us\/future-editions\/sql2012-editions.aspx?WT.mc_id=aff-n-in-loc--pd\">major versions<\/a> are:<\/p>\n<ul>\n<li>Enterprise: moves up to replace the now gone Datacenter, and is only licensed on a per-core basis.&#160; Yup, not server + CAL. <\/li>\n<li>Business Intelligence (BI): slots in the middle and is only available under server + CAL (just to confuse). <\/li>\n<li>Standard: Available under server + CAL, as well as per-core. <\/li>\n<\/ul>\n<p>By the way, there is a lovely contradiction about Enterprise being available and limited on server + CAL basis.&#160; But everywhere else, it says per Core only for this edition.&#160; There\u2019s a reason (see later).<\/p>\n<p><a href=\"https:\/\/aidanfinn.com\/wp-content\/uploads\/2011\/11\/image.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: block; float: none; border-top-width: 0px; border-bottom-width: 0px; margin-left: auto; border-left-width: 0px; margin-right: auto; padding-top: 0px\" title=\"image\" border=\"0\" alt=\"image\" src=\"https:\/\/aidanfinn.com\/wp-content\/uploads\/2011\/11\/image_thumb.png\" width=\"604\" height=\"232\" \/><\/a><\/p>\n<p>We are <a href=\"http:\/\/download.microsoft.com\/download\/D\/A\/D\/DADBE8BD-D5C7-4417-9527-5E9A717D8E84\/SQLServer2012_Licensing_Datasheet_Nov2011.docx\">told<\/a> that:<\/p>\n<p><i>\u201cSQL Server 2012 will continue to be available in Developer, Express and Compact editions. Web Edition will be offered in a Services Provider <strong>License<\/strong><b> <\/b>Agreement (SPLA \u2013 hosting licensing) model only. Datacenter Edition is being retired with all capabilities now available in Enterprise. Workgroup and Small business Editions are also being retired\u201d.<\/i><\/p>\n<p>If you are licensing per core then you buy the licenses in 2-core packs, with a minimum of 4 cores per physical processor.<\/p>\n<p><a href=\"https:\/\/aidanfinn.com\/wp-content\/uploads\/2011\/11\/image1.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: block; float: none; border-top-width: 0px; border-bottom-width: 0px; margin-left: auto; border-left-width: 0px; margin-right: auto; padding-top: 0px\" title=\"image\" border=\"0\" alt=\"image\" src=\"https:\/\/aidanfinn.com\/wp-content\/uploads\/2011\/11\/image_thumb1.png\" width=\"604\" height=\"166\" \/><\/a><\/p>\n<p>If you are licensing on a per-VM basis then you have two options:<\/p>\n<p><a href=\"https:\/\/aidanfinn.com\/wp-content\/uploads\/2011\/11\/image2.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: block; float: none; border-top-width: 0px; border-bottom-width: 0px; margin-left: auto; border-left-width: 0px; margin-right: auto; padding-top: 0px\" title=\"image\" border=\"0\" alt=\"image\" src=\"https:\/\/aidanfinn.com\/wp-content\/uploads\/2011\/11\/image_thumb2.png\" width=\"604\" height=\"324\" \/><\/a><\/p>\n<p>Note how they are counting virtual cores?&#160; It used to be that we had a formula to count physical CPUs being used by the VM and licensed that.&#160; Maybe the price works out similarly \u2013 I\u2019ll have to check that out later.<\/p>\n<p>More on <a href=\"http:\/\/www.microsoft.com\/sqlserver\/en\/us\/future-editions\/sql2012-licensing.aspx\">virtualised<\/a> SQL 2012:<\/p>\n<ul>\n<li><em>To license a VM with core-based licenses, simply pay for the virtual cores allocated within the virtual machine (minimum of 4 core licenses per VM). <\/em><\/li>\n<li><em>To license a VM under the Server + CAL model (for the Business Intelligence and Standard Editions of SQL Server 2012), you can buy the server license and buy associated SQL Server CALs for each user. <\/em><\/li>\n<li><em>Each licensed VM that is covered with Software Assurance can be moved frequently within your server farm or to a third party hoster or cloud services provider. <\/em><\/li>\n<li><em>The Enterprise Edition with Software Assurance allows you to deploy an unlimited number of database VMs on the server (or server farm) in a heavily consolidated virtualized deployment to achieve further savings.<\/em> <\/li>\n<\/ul>\n<p>They note that:<\/p>\n<ul>\n<li><em>Further savings can be achieved by operating a database server utility or SQL private cloud. This is a great option for customers who want to take advantage of the full computing power of their physical servers and have very dynamic provisioning and de-provisioning of virtual resources. <\/em><\/li>\n<li><em>Customers will be able to deploy an unlimited number of virtual machines on the server and utilize the full capacity of the licensed hardware. <\/em><\/li>\n<li><em>They can do so by fully licensing the server (or server farm) with Enterprise Edition core licenses and Software Assurance based on the total number of physical cores on the servers.&#160; This allows customers the ability to have unlimited virtual machines to handle their dynamic workloads and fully utilize the hardware\u2019s computing power.<\/em> <\/li>\n<\/ul>\n<p>In other words, if you will have lots of SQL VMs then you should have a dedicated virtualisation (any platform) cluster for your SQL VMs, and license it using Enterprise per-core licenses with SA.&#160; That\u2019s what we currently advise to save on licensing \u2013 you have to do the maths on additional Windows Server + hardware + power + management time\/licenses VS SQL license cost reduction.<\/p>\n<p>If you want to license Enterprise SQL via server + CAL then you better move quick:<\/p>\n<p><em>\u201cNew Server licenses for EE will only be available for purchase through 6\/30\/2011. Additional EE licenses in the Server and CAL license model will not be sold thereafter.<\/em><\/p>\n<p><em>Both newly purchased Server licenses for SQL Server EE 2012 or EE licenses with SA upgraded to SQL Server EE 2012 will be <b>limited to server deployments with 20 cores or less. <\/b>If you purchased SQL Server 2008 R2 Enterprise Edition in the Server + CAL model with Software Assurance and at the launch of SQL Server 2012 are running on a server with &gt; 20 physical cores, contact your Microsoft representative for help transitioning to the new licensing model\u201d.<\/em><\/p>\n<p>The SA upgrade story looks confusing.&#160; I\u2019m not going to try interpret it.&#160; I\u2019ll leave it with this thought \u2026. WTF are they thinking and who OKd this!?!?!&#160; I\u2019ve said it before and I\u2019ll say it in public now: this stuff makes an EU treaty look easy to comprehend.&#160; My advice to MSFT is to burn the licensing rules, and start over.<\/p>\n<p>BTW, I am one to <a href=\"https:\/\/aidanfinn.com\/?p=11125\">say I told you so<\/a>:<\/p>\n<p><em>\u201cMicrosoft licensing never stays still for very long. Microsoft licensing is a maze of complexity that even the experts argue over. Microsoft will lose revenue as host\/CPU capacities continue to grow unless they make a change. And Microsoft is not in the business of losing money\u201d.<\/em><\/p>\n<div style=\"padding-bottom: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; float: none; padding-top: 0px\" id=\"scid:0767317B-992E-4b12-91E0-4F059A8CECA8:55cd14f9-2e93-4b69-9f1c-2934c1b628bd\" class=\"wlWriterEditableSmartContent\">Technorati Tags: <a href=\"http:\/\/technorati.com\/tags\/Licensing\" rel=\"tag\">Licensing<\/a>,<a href=\"http:\/\/technorati.com\/tags\/Virtualisation\" rel=\"tag\">Virtualisation<\/a>,<a href=\"http:\/\/technorati.com\/tags\/SQL\" rel=\"tag\">SQL<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Every year they promise us simplification.&#160; Let\u2019s see how they\u2019ve score this time around \u2026 The major versions are: Enterprise: moves up to replace the now gone Datacenter, and is only licensed on a per-core basis.&#160; Yup, not server + CAL. Business Intelligence (BI): slots in the middle and is only available under server + &hellip; <a href=\"https:\/\/aidanfinn.com\/?p=11890\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;SQL 2012 Editions &#038; Licensing Announced \u2026 What Are They Smoking?&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[39],"tags":[183,192,195],"class_list":["post-11890","post","type-post","status-publish","format-standard","hentry","category-sql","tag-licensing","tag-sql","tag-virtualisation"],"aioseo_notices":[],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/11890","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11890"}],"version-history":[{"count":0,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/11890\/revisions"}],"wp:attachment":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}