{"id":1765,"date":"2019-12-03T16:00:12","date_gmt":"2019-12-04T00:00:12","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1765"},"modified":"2020-08-04T17:06:25","modified_gmt":"2020-08-05T00:06:25","slug":"glenns-tech-insights-for-december-3-2019","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-december-3-2019\/","title":{"rendered":"Glenn&rsquo;s Technical Insights For December 3, 2019"},"content":{"rendered":"<p><span style=\"font-size: small;\"><em>(Glenn\u2019s Technical Insights\u2026<\/em> used to be part of our bi-weekly <\/span><a href=\"https:\/\/www.sqlskills.com\/join-the-sqlskills-insider-community\/\"><span style=\"font-size: small;\">newsletter<\/span><\/a><span style=\"font-size: small;\"> but we decided to make it a regular blog post instead so it can get more visibility. It covers new hardware and software developments that are generally relevant for SQL Server). It also can just be other technically-oriented items that I find interesting.<\/span><\/p>\n<h2><span style=\"font-size: medium;\"><span style=\"font-weight: bold;\">Intel Releases Cascade Lake-X HEDT Processors<\/span><\/span><\/h2>\n<p><span style=\"font-size: small;\">On November 25, Intel released their new line of 14nm high-end desktop (HEDT) processors which is the Cascade Lake-X family. This is the latest iteration of Intel\u2019s <a href=\"https:\/\/ark.intel.com\/content\/www\/us\/en\/ark\/products\/series\/123588\/intel-core-x-series-processors.html\">Core X-series Processors<\/a> which have traditionally been their most expensive non-Xeon processors. This release includes four SKUs, ranging from 10C\/20T up to 18C\/36T.<\/span><\/p>\n<blockquote><p><span style=\"font-size: small;\"><a href=\"https:\/\/ark.intel.com\/content\/www\/us\/en\/ark\/products\/198017\/intel-core-i9-10980xe-extreme-edition-processor-24-75m-cache-3-00-ghz.html\">Intel Core i9-10980XE<\/a>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 18C\/36T\u00a0\u00a0\u00a0\u00a0\u00a0 $979.00<\/span><\/p>\n<p><span style=\"font-size: small;\"><a href=\"https:\/\/ark.intel.com\/content\/www\/us\/en\/ark\/products\/198014\/intel-core-i9-10940x-x-series-processor-19-25m-cache-3-30-ghz.html\">Intel Core i9-10940X<\/a>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14C\/28T\u00a0\u00a0\u00a0\u00a0\u00a0 $784.00<\/span><\/p>\n<p><span style=\"font-size: small;\"><a href=\"https:\/\/ark.intel.com\/content\/www\/us\/en\/ark\/products\/198012\/intel-core-i9-10920x-x-series-processor-19-25m-cache-3-50-ghz.html\">Intel Core i9-10920X<\/a>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12C\/24T\u00a0\u00a0\u00a0\u00a0\u00a0 $689.00<\/span><\/p>\n<p><span style=\"font-size: small;\"><a href=\"https:\/\/ark.intel.com\/content\/www\/us\/en\/ark\/products\/198019\/intel-core-i9-10900x-x-series-processor-19-25m-cache-3-70-ghz.html\">Intel Core i9-10900X<\/a>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10C\/20T\u00a0\u00a0\u00a0\u00a0\u00a0 $590.00<\/span><\/p><\/blockquote>\n<p><span style=\"font-size: small;\">These prices are roughly 50% lower than the previous generation Skylake-X Refresh HEDT processors. Given Intel\u2019s poor competitive position right now, a large price cut was about they best they could do to try to make this release more attractive. Even a 50% price cut doesn\u2019t actually seem to be enough given the benchmark results for these processors.<\/span><\/p>\n<p><span style=\"font-size: small;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/12\/intel-cascade-lake-pricing.jpg\"><img fetchpriority=\"high\" decoding=\"async\" style=\"display: inline; background-image: none;\" title=\"Intel-Cascade-Lake-Pricing\" src=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/12\/intel-cascade-lake-pricing_thumb.jpg\" alt=\"Intel-Cascade-Lake-Pricing\" width=\"1028\" height=\"439\" border=\"0\" \/><\/a><\/span><\/p>\n<p><span style=\"font-size: small;\"><strong>Figure 1: Intel Cascade Lake-X Details<\/strong><\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<p><span style=\"font-size: small;\">Interestingly, there is no 16C\/32T SKU in this generation (which would replace the previous generation <a href=\"https:\/\/ark.intel.com\/content\/www\/us\/en\/ark\/products\/189123\/intel-core-i9-9960x-x-series-processor-22m-cache-up-to-4-50-ghz.html\">Core i9-9960X<\/a>). I think it is pretty likely that Intel purposely skipped that SKU because it would not compare very well to the new 16C\/32T AMD Ryzen 9 3950X. <\/span><\/p>\n<p><span style=\"font-size: small;\">The reviews (and benchmark results) for these four new HEDT processors have been almost universally negative. These processors use the pretty ancient X299 chipset, which is lacking several modern features. What is really bad for Intel is that their new \u201cflagship\u201d Core i9-10980XE HEDT processor is beaten by the new AMD Ryzen 9 3950X mainstream desktop processor in many benchmarks, even though it costs about $200 more. It is also completely dominated by the new, more expensive 7nm AMD Ryzen Threadripper 3960X and 3970X HEDT processors in most benchmarks.<\/span><\/p>\n<p><span style=\"font-size: small;\">Here are a few reviews:<\/span><\/p>\n<ul>\n<li><span style=\"font-size: small;\"><a href=\"https:\/\/www.anandtech.com\/show\/15039\/the-intel-core-i9-10980xe-review\">It\u2019s a Cascade of 14nm CPUs: AnandTech\u2019s Intel Core i9-10980XE Review<\/a><\/span><\/li>\n<li><span style=\"font-size: small;\"><a href=\"https:\/\/www.tomshardware.com\/reviews\/intel-core-i9-10980xe\">Intel Core i9-10980XE Review: Intel Loses its Grip on HEDT<\/a><\/span><\/li>\n<li><span style=\"font-size: small;\"><a href=\"https:\/\/www.youtube.com\/watch?v=W32jbZ2z8wI\">Ryzen 9 3950X vs. Entire Intel Cascade Lake-X Lineup, Core i9-10900X, 10920X, 10940X &amp; 10980X<\/a><\/span><\/li>\n<\/ul>\n<h2><span style=\"font-size: medium;\"><span style=\"font-weight: bold;\">Conclusion<\/span><\/span><\/h2>\n<p><span style=\"font-size: small;\">In my mind, there are really not too many scenarios where these processors would be a good choice for a new machine build. They do not compare well to to the less expensive mainstream desktop Ryzen 9 processors for single-threaded or multi-threaded performance (or platform features). They also do not fare very well against the more expensive 3rd Generation AMD Threadripper processors for more serious content creation workloads.<\/span><\/p>\n<p><span style=\"font-size: small;\">I would argue that semi-serious content creators would be better off with a 12C\/24T AMD Ryzen 9 3900X or a 16C\/32T AMD Ryzen 9 3950X instead of any of these Cascade Lake-X processors. If you literally make your living off of content creation tasks, it is an easy decision to step up to a 3rd Generation AMD Threadripper system.<\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>(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 new hardware and software developments that are generally relevant for SQL Server). It also can just be other technically-oriented items that I find interesting. Intel [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[432],"tags":[433],"class_list":["post-1765","post","type-post","status-publish","format-standard","hentry","category-glenns-technical-insights","tag-glenns-tech-insights"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Glenn&rsquo;s Technical Insights For December 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-december-3-2019\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Glenn&rsquo;s Technical Insights For December 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 new hardware and software developments that are generally relevant for SQL Server). It also can just be other technically-oriented items that I find interesting. Intel [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-december-3-2019\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-04T00:00:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-05T00:06:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/12\/intel-cascade-lake-pricing_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-december-3-2019\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-december-3-2019\/\",\"name\":\"Glenn&rsquo;s Technical Insights For December 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-december-3-2019\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-december-3-2019\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/12\/intel-cascade-lake-pricing_thumb.jpg\",\"datePublished\":\"2019-12-04T00:00:12+00:00\",\"dateModified\":\"2020-08-05T00:06:25+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-december-3-2019\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-december-3-2019\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-december-3-2019\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/12\/intel-cascade-lake-pricing_thumb.jpg\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/12\/intel-cascade-lake-pricing_thumb.jpg\",\"width\":1028,\"height\":439},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-december-3-2019\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Glenn&rsquo;s Technical Insights For December 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&rsquo;s Technical Insights For December 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-december-3-2019\/","og_locale":"en_US","og_type":"article","og_title":"Glenn&rsquo;s Technical Insights For December 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 new hardware and software developments that are generally relevant for SQL Server). It also can just be other technically-oriented items that I find interesting. Intel [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-december-3-2019\/","og_site_name":"Glenn Berry","article_published_time":"2019-12-04T00:00:12+00:00","article_modified_time":"2020-08-05T00:06:25+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/12\/intel-cascade-lake-pricing_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-december-3-2019\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-december-3-2019\/","name":"Glenn&rsquo;s Technical Insights For December 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-december-3-2019\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-december-3-2019\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/12\/intel-cascade-lake-pricing_thumb.jpg","datePublished":"2019-12-04T00:00:12+00:00","dateModified":"2020-08-05T00:06:25+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-december-3-2019\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-december-3-2019\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-december-3-2019\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/12\/intel-cascade-lake-pricing_thumb.jpg","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/12\/intel-cascade-lake-pricing_thumb.jpg","width":1028,"height":439},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-december-3-2019\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Glenn&rsquo;s Technical Insights For December 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\/1765","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=1765"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1765\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1765"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1765"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1765"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}