Athlon 64 X2<\/a>. This processor had two discrete physical cores, which provided better multi-threaded performance than hyper-threading. A single, dual-core processor would have two processor cores visible to Windows. It is important to remember that Windows Server 2008 R2 Task Manager (and some SQL Server DMVs) cannot easily tell the difference between hyper-threaded logical processors and true dual-core or multi-core processors.<\/p>\nIn late 2006, Intel introduced the first Core2 Quad, which was a processor with four physical cores (but no hyper-threading). One of these processors would have four cores visible to Windows. Since then, both AMD and Intel have been rapidly increasing the physical core counts of their processors. AMD has the Opteron 63xx processor family which has 16 physical cores in a single physical processor. Intel has the Xeon E7 Family \u201cWestmere-EX\u201d, which has up to ten physical cores, plus 2nd generation hyper-threading, which means that you have a total of 20 logical cores visible to Windows and SQL Server for each physical processor.<\/p>\n
Before SQL Server 2012, SQL Server licensing was only concerned with physical processor sockets, not physical cores, or logical cores. Knowing this, you wanted to always<\/em><\/strong> buy processors with as many cores as possible in order to maximize your overall processor performance per processor license. You should also be aware that SQL Server 2008 is limited to 64 logical processors. In order to use more than 64 logical processors, you must be running SQL Server 2008 R2 on top of Windows Server 2008 R2, which will raise your limit to 256 logical processors.<\/p>\nSQL Server 2008 R2 Enterprise Edition also had a license limit of eight physical processors (which would let you go up to 160 logical processors with eight Intel Westmere-EX processors). If you need more than eight physical processors, you needed to run SQL Server 2008 R2 Data Center Edition. Microsoft got rid of the Data Center Edition SKU for SQL Server 2012.<\/p>\n
With SQL Server 2012, Microsoft completely changed their licensing model compared to previous releases. With SQL Server 2012 Enterprise Edition, in a non-virtualized environment, you must<\/strong><\/span> use core-based licensing, which is based on physical cores (not logical cores). Each processor socket must have at least four processor core licenses (even if there are actually only one or two physical cores). This means you need to be much more thoughtful about which exact processor model you select for your database server. Having lots of physical cores can add up to a very large amount of money for your SQL Server 2012 Enterprise Edition license costs. If you are running SQL Server 2012 Enterprise Edition on top of Windows Server 2012 Standard Edition, you can now have up to 640 logical cores, along with 4TB of RAM in your system.<\/p>\nThis new licensing system really penalizes AMD processors, which can have up to 16 physical cores in each processor, but unfortunately, have pretty mediocre single-threaded performance. To try and level the playing field a little bit, Microsoft released something called the SQL Server Core Factor Table, which gives a 25% discount for most modern AMD processors that have six or more physical cores. Even with this discount, it is far more expensive to buy your SQL Server 2012 core licenses for an AMD system compared to an equivalent Intel system.<\/p>\n
Remember that the sys.dm_os_sys_info DMV cannot tell the difference between physical and logical cores. Running the query below will tell you how many logical cores are visible and how many physical CPUs you have.<\/p>\n
\n
\n
1:<\/span> -- Hardware information from SQL Server 2012<\/span><\/pre>\n<\/p>\n
2:<\/span> -- (Cannot distinguish between HT and multi-core)<\/span><\/pre>\n<\/p>\n
3:<\/span> SELECT<\/span> cpu_count AS<\/span> [Logical CPU Count<\/span>], hyperthread_ratio AS<\/span> [Hyperthread Ratio],<\/pre>\n<\/p>\n
4:<\/span> cpu_count\/hyperthread_ratio AS<\/span> [Physical CPU Count<\/span>],<\/pre>\n<\/p>\n
5:<\/span> physical_memory_kb\/1024 AS<\/span> [Physical Memory (MB)], committed_target_kb\/1024 AS<\/span> [Committed Target Memory (MB)],<\/pre>\n<\/p>\n
6:<\/span> max_workers_count AS<\/span> [Max<\/span> Workers Count<\/span>], affinity_type_desc AS<\/span> [Affinity Type],<\/pre>\n<\/p>\n
7:<\/span> sqlserver_start_time AS<\/span> [SQL<\/span> Server Start<\/span> Time<\/span>], virtual_machine_type_desc AS<\/span> [Virtual Machine Type]<\/pre>\n<\/p>\n
8:<\/span> FROM<\/span> sys.dm_os_sys_info WITH<\/span> (NOLOCK) OPTION<\/span> (RECOMPILE);<\/pre>\n<\/p>\n
9:<\/span><\/pre>\n<\/p>\n
10:<\/span> -- Gives you some<\/span> good basic hardware information about your database<\/span> server<\/pre>\n<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
I witnessed an interesting conversation on Twitter today where someone was talking about how he uses the terms sockets and cores interchangeably, since everyone else does, or words to that effect. This made me think that there may still be some confusion about how these terms are used and what they mean in relation to […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,17,20,24,31,38,39],"tags":[103],"class_list":["post-664","post","type-post","status-publish","format-standard","hentry","category-amd","category-sql-server-hardware","category-intel","category-processors","category-sql-server-2012","category-westmere-ex","category-windows-server-2012","tag-sql-server-2012-licensing"],"yoast_head":"\n
What is the Difference Between Physical Sockets, Physical Cores, and Logical Cores? - Glenn Berry<\/title>\n<meta name=\"description\" content=\"Describes the differences between Physical Sockets, Physical Cores, and Logical Cores for SQL Server 2012 licensing usage and server hardware\" \/>\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.sqlskills.com\/blogs\/glenn\/what-is-the-difference-between-physical-sockets-physical-cores-and-logical-cores\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is the Difference Between Physical Sockets, Physical Cores, and Logical Cores? - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"Describes the differences between Physical Sockets, Physical Cores, and Logical Cores for SQL Server 2012 licensing usage and server hardware\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/what-is-the-difference-between-physical-sockets-physical-cores-and-logical-cores\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2013-03-25T22:32:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-05-14T20:20:08+00:00\" \/>\n<meta name=\"author\" content=\"Glenn Berry\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Glenn Berry\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/what-is-the-difference-between-physical-sockets-physical-cores-and-logical-cores\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/what-is-the-difference-between-physical-sockets-physical-cores-and-logical-cores\/\",\"name\":\"What is the Difference Between Physical Sockets, Physical Cores, and Logical Cores? - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2013-03-25T22:32:23+00:00\",\"dateModified\":\"2019-05-14T20:20:08+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"description\":\"Describes the differences between Physical Sockets, Physical Cores, and Logical Cores for SQL Server 2012 licensing usage and server hardware\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/what-is-the-difference-between-physical-sockets-physical-cores-and-logical-cores\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/what-is-the-difference-between-physical-sockets-physical-cores-and-logical-cores\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/what-is-the-difference-between-physical-sockets-physical-cores-and-logical-cores\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is the Difference Between Physical Sockets, Physical Cores, and Logical Cores?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\",\"name\":\"Glenn Berry\",\"description\":\"Semi-random musings about SQL Server performance\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\",\"name\":\"Glenn Berry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"caption\":\"Glenn Berry\"},\"sameAs\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is the Difference Between Physical Sockets, Physical Cores, and Logical Cores? - Glenn Berry","description":"Describes the differences between Physical Sockets, Physical Cores, and Logical Cores for SQL Server 2012 licensing usage and server hardware","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.sqlskills.com\/blogs\/glenn\/what-is-the-difference-between-physical-sockets-physical-cores-and-logical-cores\/","og_locale":"en_US","og_type":"article","og_title":"What is the Difference Between Physical Sockets, Physical Cores, and Logical Cores? - Glenn Berry","og_description":"Describes the differences between Physical Sockets, Physical Cores, and Logical Cores for SQL Server 2012 licensing usage and server hardware","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/what-is-the-difference-between-physical-sockets-physical-cores-and-logical-cores\/","og_site_name":"Glenn Berry","article_published_time":"2013-03-25T22:32:23+00:00","article_modified_time":"2019-05-14T20:20:08+00:00","author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/what-is-the-difference-between-physical-sockets-physical-cores-and-logical-cores\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/what-is-the-difference-between-physical-sockets-physical-cores-and-logical-cores\/","name":"What is the Difference Between Physical Sockets, Physical Cores, and Logical Cores? - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2013-03-25T22:32:23+00:00","dateModified":"2019-05-14T20:20:08+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"description":"Describes the differences between Physical Sockets, Physical Cores, and Logical Cores for SQL Server 2012 licensing usage and server hardware","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/what-is-the-difference-between-physical-sockets-physical-cores-and-logical-cores\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/what-is-the-difference-between-physical-sockets-physical-cores-and-logical-cores\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/what-is-the-difference-between-physical-sockets-physical-cores-and-logical-cores\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"What is the Difference Between Physical Sockets, Physical Cores, and Logical Cores?"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/","name":"Glenn Berry","description":"Semi-random musings about SQL Server performance","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/glenn\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7","name":"Glenn Berry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","caption":"Glenn Berry"},"sameAs":["https:\/\/www.sqlskills.com\/blogs\/glenn\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/664","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/comments?post=664"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/664\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=664"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}