{"id":1237,"date":"2017-08-11T10:38:58","date_gmt":"2017-08-11T17:38:58","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1237"},"modified":"2020-01-11T12:51:56","modified_gmt":"2020-01-11T20:51:56","slug":"upgrading-sql-server-preferred-amd-epyc-7000-processors","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/","title":{"rendered":"Upgrading SQL Server&ndash;Preferred AMD EPYC 7000 Processors"},"content":{"rendered":"<p>Yesterday <a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-day-10\/\">I talked about the critical importance<\/a> of thoughtful processor selection for SQL Server as part of the upgrade and migration process, and I supplied a list of \u201cpreferred\u201d Intel Scalable Processor family (Skylake-SP) processors at various physical core counts.<\/p>\n<p>Today, I am going to cover a similar list for the new <a href=\"http:\/\/www.amd.com\/en\/products\/epyc-7000-series\">AMD EYPC 7000 Series<\/a> of processors for one and two-socket servers that were launched on June 20, 2017. These are based on the <a href=\"https:\/\/www.servethehome.com\/amd-epyc-7000-series-architecture-overview-non-ce-ee-majors\/\">same Zen architecture<\/a> used on the AMD Ryzen desktop processors. The series begins with two-socket processor models designed to offer more physical cores, memory bandwidth, and PCIe 3.0 lanes compared to the current <a href=\"http:\/\/ark.intel.com\/products\/series\/125191\/Intel-Xeon-Scalable-Processors\">Intel Scalable Processor family<\/a> or the previous generation <a href=\"http:\/\/ark.intel.com\/products\/series\/91287\/Intel-Xeon-Processor-E5-v4-Family\">Intel Xeon E5-2600 v4 family<\/a> processors.<\/p>\n<p>There are nine different models for two-socket servers, ranging from the eight-core <a href=\"http:\/\/www.amd.com\/en\/products\/cpu\/amd-epyc-7251\">EPYC 7251<\/a> to the 32-core <a href=\"http:\/\/www.amd.com\/en\/products\/cpu\/amd-epyc-7601\">EPYC 7601<\/a>. All of these models have SMT (AMD\u2019s version of hyper-threading), and Max Boost (AMD\u2019s version of Turbo Boost). They also offer eight-channels of DDR4-2666 support (that have a total capacity of 2TB of RAM per socket) and 128 PCIe 3.0 lanes per socket.  <\/p>\n<p>There are three models specifically for one-socket servers (that have a P model number suffix), ranging from the 16-core <a href=\"http:\/\/www.amd.com\/en\/products\/cpu\/amd-epyc-7351p\">EPYC 7351P<\/a> to the 32-core <a href=\"http:\/\/www.amd.com\/en\/products\/cpu\/amd-epyc-7551p\">EPYC 7551P<\/a>. You can also use a non-P SKU in a one-socket server. All of these models have SMT, and Max Boost. They also offer eight-channels of DDR4-2666 support (that have a total capacity of 2TB of RAM) and 128 PCIe 3.0 lanes per socket. Unlike Intel, AMD does not artificially cripple some SKUs for product differentiation purposes.  <\/p>\n<p>Each physical processor has four Core Complexes (CCX) tied together with something AMD calls <a href=\"https:\/\/en.wikichip.org\/wiki\/amd\/infinity_fabric\">Infinity Fabric<\/a>. Infinity Fabric consists of a Scalable Data Fabric (SDF) and a Scalable Control Fabric (SCF), and it is used for both intra-processor and socket-to-socket communication. Each physical processor shows up as four NUMA nodes in Windows.  <\/p>\n<p>Unlike Intel, AMD is not increasing the base clock speed in the lower core count models. They do have multiple SKUs available with 16, 24, and 32 physical cores, with slightly different base and max boost clock speeds.  <\/p>\n<p>For SQL Server usage, you would still want the \u201ctop of the line\u201d SKU for a given physical core count, to get the most performance for each physical core license that you buy. These EPYC systems will have a lot of PCIe 3.0 lanes and very high memory density, so they might work very well for large SQL Server DW\/Reporting workloads.  <\/p>\n<p>Compared to Intel, the number of processor choices (and confusion is much lower), as shown in Figure 1.  <\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2017\/08\/Picture4-1.png\"><img fetchpriority=\"high\" decoding=\"async\" title=\"Picture4\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"Picture4\" src=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2017\/08\/Picture4_thumb-1.png\" width=\"1028\" height=\"249\"><\/a>  <\/p>\n<p><strong>Figure 1: Preferred AMD EPYC 7000 Series Processors for SQL Server Usage<\/strong><\/p>\n<p>Patrick Kennedy at <a href=\"https:\/\/www.servethehome.com\/\">ServeTheHome<\/a> has been doing a lot of <a href=\"https:\/\/www.servethehome.com\/dual-amd-epyc-7601-processor-performance-and-review-part-1\/\">benchmarking and good analysis<\/a> of early AMD EPYC systems, showing the importance of using DDR4 2666 memory, and having new BIOS\/firmware updates.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><u><font size=\"4\">Additional Resources<\/font><\/u><\/strong>  <\/p>\n<p>I have a new <a href=\"https:\/\/www.pluralsight.com\/\">Pluralsight<\/a> course, <a href=\"https:\/\/www.pluralsight.com\/courses\/sqlserver-2016-upgrading-migrating\">SQL Server: Upgrading and Migrating to SQL Server 2016<\/a> has just been published. This is my eleventh course for Pluralsight, but the complete <a href=\"https:\/\/www.pluralsight.com\/authors\/glenn-berry\">list of my courses is here<\/a>.  <\/p>\n<p>Building on this online course is a new three day class, <a href=\"https:\/\/www.sqlskills.com\/sql-server-training\/ieupgrade\/\">IEUpgrade: Immersion Event on Upgrading SQL Server<\/a>, taught by <a href=\"https:\/\/www.sqlskills.com\/about\/glenn-berry\/\">myself<\/a> and <a href=\"https:\/\/www.sqlskills.com\/about\/tim-radney\/\">Tim Radney<\/a>. The first round of this course will be taught in Chicago from October 11-13, 2017.  <\/p>\n<p>Finally, I will be presenting a half-day session called <a href=\"http:\/\/www.pass.org\/summit\/2017\/Sessions\/Details.aspx?sid=67126\">Migrating to SQL Server 2017<\/a> at the <a href=\"http:\/\/www.pass.org\/summit\/2017\/Welcome.aspx\">PASS Summit 2017<\/a> in Seattle, WA from October 31- November 3, 2017.  <\/p>\n<p>&nbsp; <\/p>\n<p>Here is a <a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/category\/upgrading-sql-server\/\">link to the complete series<\/a> about upgrading SQL Server. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Yesterday I talked about the critical importance of thoughtful processor selection for SQL Server as part of the upgrade and migration process, and I supplied a list of \u201cpreferred\u201d Intel Scalable Processor family (Skylake-SP) processors at various physical core counts. Today, I am going to cover a similar list for the new AMD EYPC 7000 [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[246,342,353],"tags":[350,352],"class_list":["post-1237","post","type-post","status-publish","format-standard","hentry","category-sql-server-2016","category-sql-server-2017","category-upgrading-sql-server","tag-upgrading-to-sql-server-2016","tag-upgrading-to-sql-server-2017"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Upgrading SQL Server&ndash;Preferred AMD EPYC 7000 Processors - Glenn Berry<\/title>\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\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upgrading SQL Server&ndash;Preferred AMD EPYC 7000 Processors - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"Yesterday I talked about the critical importance of thoughtful processor selection for SQL Server as part of the upgrade and migration process, and I supplied a list of \u201cpreferred\u201d Intel Scalable Processor family (Skylake-SP) processors at various physical core counts. Today, I am going to cover a similar list for the new AMD EYPC 7000 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2017-08-11T17:38:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-11T20:51:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2017\/08\/Picture4_thumb-1.png\" \/>\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=\"3 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\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/\",\"name\":\"Upgrading SQL Server&ndash;Preferred AMD EPYC 7000 Processors - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2017\/08\/Picture4_thumb-1.png\",\"datePublished\":\"2017-08-11T17:38:58+00:00\",\"dateModified\":\"2020-01-11T20:51:56+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2017\/08\/Picture4_thumb-1.png\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2017\/08\/Picture4_thumb-1.png\",\"width\":1028,\"height\":249},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upgrading SQL Server&ndash;Preferred AMD EPYC 7000 Processors\"}]},{\"@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":"Upgrading SQL Server&ndash;Preferred AMD EPYC 7000 Processors - Glenn Berry","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\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/","og_locale":"en_US","og_type":"article","og_title":"Upgrading SQL Server&ndash;Preferred AMD EPYC 7000 Processors - Glenn Berry","og_description":"Yesterday I talked about the critical importance of thoughtful processor selection for SQL Server as part of the upgrade and migration process, and I supplied a list of \u201cpreferred\u201d Intel Scalable Processor family (Skylake-SP) processors at various physical core counts. Today, I am going to cover a similar list for the new AMD EYPC 7000 [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/","og_site_name":"Glenn Berry","article_published_time":"2017-08-11T17:38:58+00:00","article_modified_time":"2020-01-11T20:51:56+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2017\/08\/Picture4_thumb-1.png","type":"","width":"","height":""}],"author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/","name":"Upgrading SQL Server&ndash;Preferred AMD EPYC 7000 Processors - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2017\/08\/Picture4_thumb-1.png","datePublished":"2017-08-11T17:38:58+00:00","dateModified":"2020-01-11T20:51:56+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2017\/08\/Picture4_thumb-1.png","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2017\/08\/Picture4_thumb-1.png","width":1028,"height":249},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/upgrading-sql-server-preferred-amd-epyc-7000-processors\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Upgrading SQL Server&ndash;Preferred AMD EPYC 7000 Processors"}]},{"@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\/1237","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=1237"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1237\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}