{"id":1560,"date":"2019-04-03T10:31:03","date_gmt":"2019-04-03T17:31:03","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1560"},"modified":"2020-08-04T17:12:44","modified_gmt":"2020-08-05T00:12:44","slug":"glenns-tech-insights-for-april-3-2019","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-april-3-2019\/","title":{"rendered":"Glenn’s Technical Insights For April 3, 2019"},"content":{"rendered":"

(Glenn\u2019s Technical Insights\u2026<\/em> used to be part of our bi-weekly <\/span>newsletter<\/span><\/a> but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally relevant for SQL Server).<\/span><\/h4>\n

Intel Data-Centric Innovation Day on April 2<\/span><\/span><\/h2>\n

On April 2, 2019 Intel <\/span>streamed a live event<\/span><\/a> where they announced multiple new product lines, including the 2nd<\/sup> Generation Intel Scalable Processor Family (Cascade Lake-SP), the Intel Xeon 9200 family (Cascade Lake-AP), Optane DC Persistent Memory, new models of Optane Storage, and several other product lines.<\/span><\/p>\n

The 2nd<\/sup> Generation Intel Scalable Processor Family is going to be the most interesting for SQL Server usage. These offer minor performance improvements compared to the previous Skylake-SP line. I talked about this in more detail here:<\/span><\/p>\n

Intel Cascade Lake-SP Processor Analysis for SQL Server<\/span><\/a><\/p><\/blockquote>\n

The bottom line is that this is a pretty weak effort by Intel, for SQL Server usage. It will be a nice upgrade if you are currently running a much older processor family. For example, Sandy Bridge, Ivy Bridge, or Haswell. It is the best choice now available from Intel. Cascade Lake-SP will have to compete against the upcoming 7nm AMD EPYC Rome processors pretty soon (probably in June), and this could be a big problem for Intel. Time will tell. Figure 1 shows you how to understand what a specific Xeon SKU model name means.<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\"Second-Generation-Intel-Xeon-Scalable-Processors-Decoder-Ring\"<\/a><\/p>\n

Figure 1: Intel Processor SKU Naming<\/strong><\/span><\/p>\n

\u00a0<\/span><\/p>\n

Figure 2 shows most of the SKU list for the 2nd Generation Intel Xeon Scalable Processor line. Remember, you should never<\/u><\/strong> get a Silver or Bronze family processor for SQL Server usage. You will give up a very large amount of performance for a relatively minor hardware cost savings.<\/span><\/p>\n

\"Second-Generation-Intel-Xeon-Scalable-Processors-SKU-List-with-Pricing-Update\"<\/a><\/p>\n

Figure 2: Cascade Lake-SP SKU List with Pricing<\/strong><\/span><\/p>\n

Note: I believe that the Xeon Platinum 8256 actually has four cores, not 24 cores (based on the previous Xeon Platinum 8156 and the L3 cache size). This list does not include the Xeon Platinum 9200 series or any of the M or L SKUs (which will be very expensive).<\/span><\/p>\n

Here are some other blog posts that cover this event:<\/span><\/p>\n

2nd Gen Intel Xeon Scalable Launch Details and Analysis<\/span><\/a><\/p>\n

Second Generation Intel Xeon Scalable SKU List and Value Analysis<\/span><\/a><\/p>\n

The Intel Second Generation Xeon Scalable: Cascade Lake, Now with Up To 56-Cores and Optane!<\/span><\/a><\/p>\n

Intel Announces Cascade Lake: Up to 56 Cores and Optane Persistent Memory DIMMs<\/span><\/a><\/p><\/blockquote>\n

\u00a0<\/span><\/p>\n

Computex 2019 Keynote<\/span><\/span><\/h2>\n

AMD\u2019s CEO, Dr. Lisa Su, is going to present the opening <\/span>Computex 2019<\/span><\/a> Keynote on May 27, 2019 in Taiwan. She is expected introduce their next generation 7nm products. These include the Ryzen 3000 series mainstream desktop processors, Radeon RX Navi GPUs and the EPYC \u201cRome\u201d server processors.<\/span><\/p>\n

This event will give us more specific information about AMD\u2019s counter to Intel Cascade Lake-SP. Scottish YouTuber AdoredTV<\/a> has another great video: <\/span>Zen 2 \u2013 Even More EPYC<\/span><\/a>. This covers the latest information he has received from his confidential sources along with his thoughtful analysis.<\/span><\/p>\n

Personally, I think the AMD Rome processors will have many technical advantages compared to Intel Cascade Lake-SP. These include higher memory density, and DDR4-3200 memory support. There will be a much higher number of PCIe lanes (which will be Gen 4 instead of Gen 3). The big remaining question is how single-threaded CPU performance ends up. I think this will depend on whether AMD decides to offer frequency-optimized SKUs.<\/span><\/p>\n

Here are some recent stories about the predicted impact on the Rome processor on the server market.<\/span><\/p>\n

AMD to see sales increase sharply in 2H19<\/span><\/a><\/p>\n

AMD EPYC could force Intel’s server market share below 90 percent<\/span><\/a><\/p>\n

AMD Predicted To Further Chip Away At Intel Server CPU Market Share With EPYC Through 2020<\/span><\/a><\/p><\/blockquote>\n

Having viable competition from AMD keeps the pressure on Intel, and forces them to innovate and offer more functionality at lower prices, which is good for the market. For example, if it wasn’t for the AMD Zen architecture, Intel would probably still be releasing 4C\/8T processors as their \u201ctop of the line\u201d for desktop and mobile usage. They would also still be stuck at 10C\/20T offerings for the HEDT market.<\/span><\/p>\n

\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

(Glenn\u2019s Technical Insights\u2026 used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally relevant for SQL Server). Intel Data-Centric Innovation Day on April 2 On April 2, 2019 Intel […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[432,17],"tags":[414,425],"class_list":["post-1560","post","type-post","status-publish","format-standard","hentry","category-glenns-technical-insights","category-sql-server-hardware","tag-amd-epyc-rome","tag-intel-cascade-lake-sp"],"yoast_head":"\nGlenn’s Technical Insights For April 3, 2019 - 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\/glenns-tech-insights-for-april-3-2019\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Glenn’s Technical Insights For April 3, 2019 - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"(Glenn\u2019s Technical Insights\u2026 used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally relevant for SQL Server). Intel Data-Centric Innovation Day on April 2 On April 2, 2019 Intel […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-april-3-2019\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-03T17:31:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-05T00:12:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/second-generation-intel-xeon-scalable-processors-decoder-ring_thumb.jpg\" \/>\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\/glenns-tech-insights-for-april-3-2019\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-april-3-2019\/\",\"name\":\"Glenn’s Technical Insights For April 3, 2019 - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-april-3-2019\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-april-3-2019\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/second-generation-intel-xeon-scalable-processors-decoder-ring_thumb.jpg\",\"datePublished\":\"2019-04-03T17:31:03+00:00\",\"dateModified\":\"2020-08-05T00:12:44+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-april-3-2019\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-april-3-2019\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-april-3-2019\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/second-generation-intel-xeon-scalable-processors-decoder-ring_thumb.jpg\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/second-generation-intel-xeon-scalable-processors-decoder-ring_thumb.jpg\",\"width\":1028,\"height\":580},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-april-3-2019\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Glenn’s Technical Insights For April 3, 2019\"}]},{\"@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":"Glenn’s Technical Insights For April 3, 2019 - 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\/glenns-tech-insights-for-april-3-2019\/","og_locale":"en_US","og_type":"article","og_title":"Glenn’s Technical Insights For April 3, 2019 - Glenn Berry","og_description":"(Glenn\u2019s Technical Insights\u2026 used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally relevant for SQL Server). Intel Data-Centric Innovation Day on April 2 On April 2, 2019 Intel […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-april-3-2019\/","og_site_name":"Glenn Berry","article_published_time":"2019-04-03T17:31:03+00:00","article_modified_time":"2020-08-05T00:12:44+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/second-generation-intel-xeon-scalable-processors-decoder-ring_thumb.jpg","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\/glenns-tech-insights-for-april-3-2019\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-april-3-2019\/","name":"Glenn’s Technical Insights For April 3, 2019 - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-april-3-2019\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-april-3-2019\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/second-generation-intel-xeon-scalable-processors-decoder-ring_thumb.jpg","datePublished":"2019-04-03T17:31:03+00:00","dateModified":"2020-08-05T00:12:44+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-april-3-2019\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-april-3-2019\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-april-3-2019\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/second-generation-intel-xeon-scalable-processors-decoder-ring_thumb.jpg","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/second-generation-intel-xeon-scalable-processors-decoder-ring_thumb.jpg","width":1028,"height":580},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-april-3-2019\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Glenn’s Technical Insights For April 3, 2019"}]},{"@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\/1560","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=1560"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1560\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1560"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1560"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}