{"id":377,"date":"2016-02-19T08:03:02","date_gmt":"2016-02-19T08:03:02","guid":{"rendered":"http:\/\/www.faceofit.com\/?p=377"},"modified":"2020-04-13T07:02:38","modified_gmt":"2020-04-13T07:02:38","slug":"sql-server-2014-core-licensing","status":"publish","type":"post","link":"https:\/\/www.gigxp.com\/sql-server-2014-core-licensing\/","title":{"rendered":"How to License SQL Server 2014 : Core Licensing"},"content":{"rendered":"<p>Microsoft <strong>SQL Server 2014 Core Licensing<\/strong> method is the one that majority of the Medium to Large Enterprises would go for. It is because it gives you <em><strong>unlimited client connections<\/strong><\/em>. There is also no need for clients to purchase additional Client licenses (CALS). However, <a href=\"http:\/\/www.gigxp.com\/sql-server-2014-server-cal-licensing\/\">as explained in my previous post<\/a>, the\u00a0Server CAL model of licensing\u00a0is beneficial for smaller deployments with &#8220;Fixed&#8221; limited client connections. If you are new to SQL Server Licensing, <strong><a href=\"http:\/\/www.gigxp.com\/sql-server-2014-licensing\/\">please see this post first<\/a><\/strong>.<\/p>\n<h2>SQL Server 2014 Core Licensing<\/h2>\n<div id=\"attachment_379\" style=\"width: 906px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-379\" class=\"size-full wp-image-379\" src=\"http:\/\/www.faceofit.com\/wp-content\/uploads\/2016\/02\/Core-Licensing-1.jpg\" alt=\"Source: Microsoft Licensing Guide for SQL 2014\" width=\"896\" height=\"375\" \/><p id=\"caption-attachment-379\" class=\"wp-caption-text\">Source: Microsoft Licensing Guide for SQL 2014<\/p><\/div>\n<p>Now, here is when things can get a bit more complicated. Imagine the picture above, and understand the following terms which would be used to realize Core-Based licensing.<\/p>\n<ul>\n<li><strong>Physical Server<\/strong> &#8211; The Server (<a href=\"http:\/\/www.gigxp.com\/sql-server-licensing-in-a-vm\/\">Which is not a Virtual Machine<\/a>) on which you plan to install SQL Server 2014.<\/li>\n<li><strong>Physical Processor<\/strong> &#8211; Please refer to the picture above. Physical processors typically come from Intel &amp; AMD. They look like this:<\/li>\n<\/ul>\n<div id=\"attachment_380\" style=\"width: 319px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-380\" class=\"size-full wp-image-380\" src=\"http:\/\/www.faceofit.com\/wp-content\/uploads\/2016\/02\/amd_processor.jpg\" alt=\"source: AMD.com\" width=\"309\" height=\"211\" \/><p id=\"caption-attachment-380\" class=\"wp-caption-text\">source: AMD.com<\/p><\/div>\n<ul>\n<li><strong>Physical Core<\/strong>: Processors can contain <strong>Dual<\/strong>, <strong>Quad<\/strong>, <strong>Hex<\/strong>, <strong>Octa<\/strong> or more cores in each processor. It depends on the processor model or vendor.<\/li>\n<li><strong>Hardware Threads<\/strong>: Logical threads introduced first with Intel Hyper-Threading Technology(HTT). AMD also sells Modules instead of Cores which adds a bit to the confusion.<\/li>\n<\/ul>\n<p>You need to License all the physical cores of the Server. The exception here being <a href=\"http:\/\/www.gigxp.com\/sql-server-licensing-in-a-vm\/\">Virtual Machines<\/a>.<\/p>\n<blockquote><p><strong><span style=\"color: #ff0000;\">SQL Server 2008 R2 was the last release to come with &#8220;Per Socket Licensing&#8221;<\/span><\/strong><\/p><\/blockquote>\n<p>Here is what the official documentation says:<\/p>\n<div id=\"attachment_381\" style=\"width: 850px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-381\" class=\"size-large wp-image-381\" src=\"http:\/\/www.faceofit.com\/wp-content\/uploads\/2016\/02\/Core-Licensing-2-1024x270.png\" alt=\"Source: Microsoft Licensing Guide for SQL 2014\" width=\"840\" height=\"221\" \/><p id=\"caption-attachment-381\" class=\"wp-caption-text\">Source: Microsoft Licensing Guide for SQL 2014<\/p><\/div>\n<p>Now, here are some of the points to remember:<\/p>\n<ul>\n<li><span style=\"color: #000000;\"><strong>All physical cores on the server must be licensed (<a href=\"http:\/\/www.gigxp.com\/sql-server-licensing-in-a-vm\/\">Exceptions being a Virtual Machine<\/a>)<\/strong><\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>You need to buy a minimum number of licenses for each physical processor on the server, which is four cores.<\/strong><\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>Core Licenses are sold in an even number of packs, i.e., two pack, four pack, six packs, etc.<\/strong><\/span><\/li>\n<\/ul>\n<div id=\"attachment_382\" style=\"width: 850px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-382\" class=\"size-large wp-image-382\" src=\"http:\/\/www.faceofit.com\/wp-content\/uploads\/2016\/02\/Core-Licensing-3-1024x303.png\" alt=\"Source: Microsoft Licensing Guide for SQL 2014\" width=\"840\" height=\"249\" \/><p id=\"caption-attachment-382\" class=\"wp-caption-text\">Source: Microsoft Licensing Guide for SQL 2014<\/p><\/div>\n<p>To understand and calculate the Core factor, refer to the following table:<\/p>\n<div id=\"attachment_383\" style=\"width: 850px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-383\" class=\"size-large wp-image-383\" src=\"http:\/\/www.faceofit.com\/wp-content\/uploads\/2016\/02\/Core-Licensing-4-1024x275.png\" alt=\"Source: Microsoft Licensing Guide for SQL 2014\" width=\"840\" height=\"226\" \/><p id=\"caption-attachment-383\" class=\"wp-caption-text\">Source: Microsoft Licensing Guide for SQL 2014<\/p><\/div>\n<h3>Core-Based Licensing Considerations:<\/h3>\n<ul>\n<li>If you are buying an\u00a0<strong>SQL Server Enterprise Edition\u00a0License<\/strong>.<\/li>\n<li>When a Web-facing App is connecting to your SQL Server, the <strong>only option<\/strong> is to go for SQL Server Core-Based Licensing. This is because you will never be able to calculate the exact number of client connections which is connecting directly or indirectly to your SQL Server.<\/li>\n<li>When you have a\u00a0large number of direct and\/or indirect users\/devices, Core based licensing is cheaper than <a href=\"http:\/\/www.gigxp.com\/sql-server-2014-server-cal-licensing\/\">User\/Device CAL based licensing<\/a>.<\/li>\n<\/ul>\n<blockquote><p><strong><span style=\"color: #ff0000;\">Note: If you are using Intel based processors with\u00a0hyper-threading technology enabled, it does not affect the number of core licenses required when running SQL Server software in a physical environment.<\/span><\/strong><\/p><\/blockquote>\n<p>In my next Article, I will discuss Licensing SQL Server in a <a href=\"http:\/\/www.gigxp.com\/sql-server-licensing-in-a-vm\/\">Virtual Environment<\/a>.<\/p>\n<p>If you have suggestions or questions, please drop us a comment below in the comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft SQL Server 2014 Core Licensing method is the one that majority of the Medium to Large Enterprises would go for. It is because it gives you unlimited client connections. There is also no need for clients to purchase additional Client licenses (CALS). However, as explained in my previous post, the\u00a0Server CAL model of licensing\u00a0is beneficial for smaller deployments with &#8220;Fixed&#8221; limited client connections. If you are new to SQL Server Licensing, please see this post first. SQL Server 2014 Core Licensing Now, here is when things can get a bit more complicated. Imagine the picture above, and understand the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3161,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38,41,45],"tags":[39,42,43,46],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What is the Microsoft SQL Server 2014 Core Licensing Model<\/title>\n<meta name=\"description\" content=\"Confused about SQL Server 2014 Core Licensing. Find our Easy to Understand Literature of how to License SQL Server 2014 using the Core Model.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.gigxp.com\/sql-server-2014-core-licensing\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is the Microsoft SQL Server 2014 Core Licensing Model\" \/>\n<meta property=\"og:description\" content=\"Confused about SQL Server 2014 Core Licensing. Find our Easy to Understand Literature of how to License SQL Server 2014 using the Core Model.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.gigxp.com\/sql-server-2014-core-licensing\/\" \/>\n<meta property=\"og:site_name\" content=\"Gig XP\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/Face-of-it-501680523211743\" \/>\n<meta property=\"article:published_time\" content=\"2016-02-19T08:03:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-13T07:02:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.gigxp.com\/wp-content\/uploads\/2016\/02\/Adobe-Spark-43.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1440\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"IG\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@faceofit1\" \/>\n<meta name=\"twitter:site\" content=\"@FaceofIT1\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"IG\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.gigxp.com\/sql-server-2014-core-licensing\/\",\"url\":\"https:\/\/www.gigxp.com\/sql-server-2014-core-licensing\/\",\"name\":\"What is the Microsoft SQL Server 2014 Core Licensing Model\",\"isPartOf\":{\"@id\":\"https:\/\/www.gigxp.com\/#website\"},\"datePublished\":\"2016-02-19T08:03:02+00:00\",\"dateModified\":\"2020-04-13T07:02:38+00:00\",\"author\":{\"@id\":\"https:\/\/www.gigxp.com\/#\/schema\/person\/6244c054d0028f41846edce3a1707a2d\"},\"description\":\"Confused about SQL Server 2014 Core Licensing. Find our Easy to Understand Literature of how to License SQL Server 2014 using the Core Model.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.gigxp.com\/sql-server-2014-core-licensing\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.gigxp.com\/sql-server-2014-core-licensing\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.gigxp.com\/sql-server-2014-core-licensing\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.gigxp.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to License SQL Server 2014 : Core Licensing\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.gigxp.com\/#website\",\"url\":\"https:\/\/www.gigxp.com\/\",\"name\":\"Gig XP\",\"description\":\"The Enterprise Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.gigxp.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.gigxp.com\/#\/schema\/person\/6244c054d0028f41846edce3a1707a2d\",\"name\":\"IG\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.gigxp.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8b03fdc21ab68c3d7d72b6f7462c820b?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8b03fdc21ab68c3d7d72b6f7462c820b?s=96&d=retro&r=g\",\"caption\":\"IG\"},\"sameAs\":[\"http:\/\/faceofit.com\",\"https:\/\/twitter.com\/faceofit1\"],\"url\":\"https:\/\/www.gigxp.com\/author\/indro13\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is the Microsoft SQL Server 2014 Core Licensing Model","description":"Confused about SQL Server 2014 Core Licensing. Find our Easy to Understand Literature of how to License SQL Server 2014 using the Core Model.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.gigxp.com\/sql-server-2014-core-licensing\/","og_locale":"en_US","og_type":"article","og_title":"What is the Microsoft SQL Server 2014 Core Licensing Model","og_description":"Confused about SQL Server 2014 Core Licensing. Find our Easy to Understand Literature of how to License SQL Server 2014 using the Core Model.","og_url":"https:\/\/www.gigxp.com\/sql-server-2014-core-licensing\/","og_site_name":"Gig XP","article_publisher":"http:\/\/www.facebook.com\/Face-of-it-501680523211743","article_published_time":"2016-02-19T08:03:02+00:00","article_modified_time":"2020-04-13T07:02:38+00:00","og_image":[{"width":2560,"height":1440,"url":"https:\/\/www.gigxp.com\/wp-content\/uploads\/2016\/02\/Adobe-Spark-43.jpg","type":"image\/jpeg"}],"author":"IG","twitter_card":"summary_large_image","twitter_creator":"@faceofit1","twitter_site":"@FaceofIT1","twitter_misc":{"Written by":"IG","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.gigxp.com\/sql-server-2014-core-licensing\/","url":"https:\/\/www.gigxp.com\/sql-server-2014-core-licensing\/","name":"What is the Microsoft SQL Server 2014 Core Licensing Model","isPartOf":{"@id":"https:\/\/www.gigxp.com\/#website"},"datePublished":"2016-02-19T08:03:02+00:00","dateModified":"2020-04-13T07:02:38+00:00","author":{"@id":"https:\/\/www.gigxp.com\/#\/schema\/person\/6244c054d0028f41846edce3a1707a2d"},"description":"Confused about SQL Server 2014 Core Licensing. Find our Easy to Understand Literature of how to License SQL Server 2014 using the Core Model.","breadcrumb":{"@id":"https:\/\/www.gigxp.com\/sql-server-2014-core-licensing\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gigxp.com\/sql-server-2014-core-licensing\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.gigxp.com\/sql-server-2014-core-licensing\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gigxp.com\/"},{"@type":"ListItem","position":2,"name":"How to License SQL Server 2014 : Core Licensing"}]},{"@type":"WebSite","@id":"https:\/\/www.gigxp.com\/#website","url":"https:\/\/www.gigxp.com\/","name":"Gig XP","description":"The Enterprise Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.gigxp.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.gigxp.com\/#\/schema\/person\/6244c054d0028f41846edce3a1707a2d","name":"IG","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gigxp.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8b03fdc21ab68c3d7d72b6f7462c820b?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8b03fdc21ab68c3d7d72b6f7462c820b?s=96&d=retro&r=g","caption":"IG"},"sameAs":["http:\/\/faceofit.com","https:\/\/twitter.com\/faceofit1"],"url":"https:\/\/www.gigxp.com\/author\/indro13\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/posts\/377"}],"collection":[{"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/comments?post=377"}],"version-history":[{"count":0,"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/posts\/377\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/media\/3161"}],"wp:attachment":[{"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/media?parent=377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/categories?post=377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/tags?post=377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}