{"id":1551,"date":"2019-04-02T20:43:16","date_gmt":"2019-04-03T03:43:16","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1551"},"modified":"2020-01-11T12:51:58","modified_gmt":"2020-01-11T20:51:58","slug":"intel-cascade-lake-sp-processor-analysis-for-sql-server","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/","title":{"rendered":"Intel Cascade Lake-SP Processor Analysis for SQL Server"},"content":{"rendered":"<h2><font size=\"3\"><font style=\"font-weight: bold;\">Introduction<\/font><\/font><\/h2>\n<p><font size=\"2\">On April 2, 2019, Intel had their <a href=\"https:\/\/t.co\/xwojWC2eem\" target=\"_blank\" rel=\"noopener noreferrer\">Data-Centric Innovation Day<\/a>, where they announced and described a number of new products for data center use. Most relevant from a SQL Server perspective is the 2nd Generation Intel Scalable Processor family, aka Cascade Lake-SP. This line of 14nm processors are the successor to the existing 14nm <a href=\"https:\/\/ark.intel.com\/content\/www\/us\/en\/ark\/products\/series\/125191\/intel-xeon-scalable-processors.html\" target=\"_blank\" rel=\"noopener noreferrer\">Intel Scalable Processor family<\/a> (Skylake-SP) that was released in Q3 2017. These new processors will work with existing model servers (with a BIOS update), so there should be no delay waiting on server vendors to do a model refresh.<\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p>\n<h2><font size=\"3\"><font style=\"font-weight: bold;\">Cascade Lake-SP Improvements<\/font><\/font><\/h2>\n<p><font size=\"2\">This new family of processors has minor base and turbo clock speed improvements (typically 200 MHz). They also support DDR4-2933 RAM (at two DIMMs per channel) and 256GB LRDIMMs. This means you can have up to 1.5TB of RAM per socket, with the base, non-M or L suffix SKUs. That is a doubling of memory capacity compared to Skylake-SP. Some of the mid-range <font size=\"2\"><font size=\"2\">Cascade Lake-SP <\/font><\/font>SKUs have larger L3 cache sizes compared to the equivalent Skylake-SP SKUs. <font size=\"2\"><font size=\"2\">Cascade Lake-SP also has Optane DC Persistent Memory support and hardware-level Spectre and Meltdown mitigations. Unfortunately, there is no PCIe 4.0 support with Cascade Lake-SP.<\/font><\/font><\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p>\n<h2><font size=\"3\"><font style=\"font-weight: bold;\">Cascade Lake-SP Regressions<\/font><\/font><\/h2>\n<p><font size=\"2\">There are some issues with Cascade Lake-SP for SQL Server usage. Not from a technical or performance perspective, but from a product segmentation perspective. First, Intel has introduced a number of new model number letter suffixes which make processor selection more complicated and potentially much more expensive.<\/font><\/p>\n<p><font size=\"2\">The complete list of SKU suffix letters are as follows:<\/font><\/p>\n<ul>\n<li><font size=\"2\">No letter = Normal Memory Support (1.5 TB)<\/font><\/li>\n<li><font size=\"2\">M = Medium Memory Support (2.0 TB)<\/font><\/li>\n<li><font size=\"2\">L = Large Memory Support (4.5 TB)<\/font><\/li>\n<li><font size=\"2\">Y = Speed Select Models<\/font><\/li>\n<li><font size=\"2\">N = Networking\/NFV Specialized<\/font><\/li>\n<li><font size=\"2\">V = Virtual Machine Density Value Optimized<\/font><\/li>\n<li><font size=\"2\">T = Long Life Cycle\/Thermal<\/font><\/li>\n<li><font size=\"2\">S = Search Optimized<\/font><\/li>\n<\/ul>\n<p><font size=\"2\">Confused yet? Suffice it say, you will want to avoid those specialized SKUs for most SQL Server usage, with the possible exception of the M or L models if you need higher memory density. Another exception might be the \u201cY\u201d, Speed Select (SST) SKUs, which let you pin workloads to specific cores (which can have an increased base clock speed) while the other cores have a reduced base clock speed. Another variant of Speed Select (SST-PP) lets you vary the number of cores and clock speeds at boot time. This feature would probably be in violation of current SQL Server licensing, where Microsoft expects you to pay for all of the physical cores in a machine, whether they are enabled or not.<\/font><\/p>\n<p><font size=\"2\">If you decide to use Intel Optane DC Persistent Memory, your maximum memory speed will be reduced to DDR4-2666. Intel has not released pricing for Intel Optane DC Persistent Memory yet, which means that it will be expensive (but less expensive\/GB than DDR4 RAM).<\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p>\n<h2><font size=\"3\"><font style=\"font-weight: bold;\">Missing SKUs<\/font><\/font><\/h2>\n<p><font size=\"2\">A bigger issue for SQL Server usage is the fact Intel has apparently dropped at least two of their frequency-optimized SKUs from the previous generation. Based on today\u2019s information, I don\u2019t see a 12-core Intel Xeon Gold 6246 or a 6-core Intel Xeon Gold 6228. These would replace the previous <a href=\"https:\/\/ark.intel.com\/content\/www\/us\/en\/ark\/products\/124942\/intel-xeon-gold-6146-processor-24-75m-cache-3-20-ghz.html\" target=\"_blank\" rel=\"noopener noreferrer\">Intel Xeon Gold 6146<\/a> and <a href=\"https:\/\/ark.intel.com\/content\/www\/us\/en\/ark\/products\/120482\/intel-xeon-gold-6128-processor-19-25m-cache-3-40-ghz.html\" target=\"_blank\" rel=\"noopener noreferrer\">Intel Xeon Gold 6128<\/a>. There don\u2019t appear to be any 6-core SKUs outside of the Intel Xeon Bronze 3204 (which would be a terrible choice for SQL Server usage).<\/font><\/p>\n<p><font size=\"2\">In fact, there are only five specific Cascade Lake-SP SKUs that I really like for SQL Server usage (if you want the best single-threaded performance possible). These include:<\/font><\/p>\n<ul>\n<li><font size=\"2\">Intel Xeon Platinum 8280 (28 cores)<\/font><\/li>\n<li><font size=\"2\">Intel Xeon Platinum 8268 (24 cores)<\/font><\/li>\n<li><font size=\"2\">Intel Xeon Gold 6254 (18 cores)<\/font><\/li>\n<li><font size=\"2\">Intel Xeon Gold 6244 (8 cores)<\/font><\/li>\n<li><font size=\"2\">Intel Xeon Gold 5222 (4 cores)<\/font><\/li>\n<\/ul>\n<p><font size=\"2\">All of these SKUs have slightly higher base and turbo clock speeds than their direct Skylake-SP predecessors. All of them (except the Platinum 8168) are the same price as their predecessors. The Platinum 8268 has a larger L3 cache than the Platinum 8168, which somewhat justifies a price increase. The problem is that missing 6-core SKU and the big gap between the 8-core and the 18-core SKUs. That gap represents about $142K in SQL Server 2017 Enterprise Edition licenses costs in a two-socket server.<\/font><\/p>\n<p><font size=\"2\">Figures 1 and 2 show the main specifications for my preferred SKUs for Cascade Lake-SP and Skylake-SP (for SQL Server usage).<\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/cascade-lake-sp-list-1.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1028\" height=\"398\" title=\"Cascade Lake-SP List\" style=\"display: inline; background-image: none;\" alt=\"Cascade Lake-SP List\" src=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/cascade-lake-sp-list_thumb-1.png\" border=\"0\"><\/a><\/p>\n<p><font size=\"2\"><strong>Figure 1: Preferred Cascade Lake-SP SKUs<\/strong><\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p>\n<p><font size=\"2\">As you can see, there were fewer large gaps in the core counts of these \u201cgood\u201d processor choices for SQL Server usage with Skylake-SP.<\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p>\n<p><font size=\"2\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/skylake-sp-list-1.png\"><img decoding=\"async\" width=\"1028\" height=\"399\" title=\"Skylake-SP List\" style=\"display: inline; background-image: none;\" alt=\"Skylake-SP List\" src=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/skylake-sp-list_thumb-1.png\" border=\"0\"><\/a><\/font><\/p>\n<p><font size=\"2\"><strong>Figure 2: Preferred Skylake-SP SKUs<\/strong><\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p>\n<h2><font size=\"3\"><font style=\"font-weight: bold;\">Initial TPC-E Results<\/font><\/font><\/h2>\n<p><font size=\"2\">We already have the first TPC-E submission for a system using Cascade Lake-SP processors. Lenovo recently <a href=\"http:\/\/www.tpc.org\/tpce\/results\/tpce_result_detail.asp?id=119032901\" target=\"_blank\" rel=\"noopener noreferrer\">submitted a result<\/a> for a two-socket <a href=\"https:\/\/www.lenovo.com\/us\/en\/data-center\/servers\/racks\/ThinkSystem-SR650\/p\/77XX7SRSR65\" target=\"_blank\" rel=\"noopener noreferrer\">Lenovo ThinkSystem SR650<\/a> with two Intel Xeon Platinum 8280 processors. This system had a score of 7012.53. If you divide that score by 56 physical cores, you get a result of 125.22\/core.<\/font><\/p>\n<p><font size=\"2\">Lenovo <a href=\"http:\/\/www.tpc.org\/tpce\/results\/tpce_result_detail.asp?id=118090501\" target=\"_blank\" rel=\"noopener noreferrer\">previously submitted a result<\/a> for an essentially identical Lenovo ThinkSystem SR650 with two Intel Xeon Platinum 8180 processors This system had a score of 6779.53. If you divide that score by 56 physical cores, you get a result of 121.06\/core. <\/font><\/p>\n<p><font size=\"2\">That is about a 3.4% improvement. The difference in base clock speed is 8%. Both systems are running SQL Server 2017 Enterprise Edition on Windows Server 2016 Standard Edition. There may be some minor configuration differences between the two systems, but I have not spelunked into the full disclosure reports to determine that yet.<\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p>\n<h2><font size=\"3\"><font style=\"font-weight: bold;\">Conclusion<\/font><\/font><\/h2>\n<p><font size=\"2\">Cascade Lake-SP will give give you marginally better performance at the same core counts compared to Skylake-SP. This is primarily due to the higher base and turbo clock speeds. Higher memory bandwidth and hardware-level Spectre\/Meltdown protection will also help in some scenarios. Most of the other Cascade Lake-SP improvements are focused on HPC and AI workloads, and will not be beneficial to SQL Server 2017\/2019. <font size=\"2\">Intel is not claiming any significant IPC improvements in Cascade Lake-SP, which seems to be confirmed by the first TPC-E result. Intel Optane DC Persistent Memory may be useful, depending on how much you can leverage it with SQL Server 2019.<\/font><\/font><\/p>\n<p><font size=\"2\">Honestly, I am pretty underwhelmed by Cascade Lake-SP so far, at least for SQL Server. It is <strong><em>slightly<\/em><\/strong> better than Skylake-SP, assuming the frequency-optimized core count gaps don\u2019t force you to license more cores than you wanted to. Intel should be very concerned about the upcoming 7nm AMD EPYC \u201cRome\u201d server processors. These AMD processors will have have up to 64C\/128T, higher memory density, and more PCIe lanes (with PCIe 4.0 instead of PCIe 3.0). They also may have higher single-threaded performance than Cascade Lake-SP. This is especially likely if AMD decides to offer more frequency-optimized SKUs, like the existing AMD EPYC 7371 from the \u201cNaples\u201d generation.<\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p>\n<p><font size=\"2\"><br \/><\/font><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction On April 2, 2019, Intel had their Data-Centric Innovation Day, where they announced and described a number of new products for data center use. Most relevant from a SQL Server perspective is the 2nd Generation Intel Scalable Processor family, aka Cascade Lake-SP. This line of 14nm processors are the successor to the existing 14nm [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[434,20],"tags":[136],"class_list":["post-1551","post","type-post","status-publish","format-standard","hentry","category-cascade-lake-sp","category-intel","tag-hardware-consulting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Intel Cascade Lake-SP Processor Analysis for SQL Server - 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\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Intel Cascade Lake-SP Processor Analysis for SQL Server - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"Introduction On April 2, 2019, Intel had their Data-Centric Innovation Day, where they announced and described a number of new products for data center use. Most relevant from a SQL Server perspective is the 2nd Generation Intel Scalable Processor family, aka Cascade Lake-SP. This line of 14nm processors are the successor to the existing 14nm [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-03T03:43:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-11T20:51:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/cascade-lake-sp-list_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=\"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\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/\",\"name\":\"Intel Cascade Lake-SP Processor Analysis for SQL Server - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/cascade-lake-sp-list_thumb-1.png\",\"datePublished\":\"2019-04-03T03:43:16+00:00\",\"dateModified\":\"2020-01-11T20:51:58+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/cascade-lake-sp-list_thumb-1.png\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/cascade-lake-sp-list_thumb-1.png\",\"width\":1028,\"height\":398},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Intel Cascade Lake-SP Processor Analysis for SQL Server\"}]},{\"@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":"Intel Cascade Lake-SP Processor Analysis for SQL Server - 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\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Intel Cascade Lake-SP Processor Analysis for SQL Server - Glenn Berry","og_description":"Introduction On April 2, 2019, Intel had their Data-Centric Innovation Day, where they announced and described a number of new products for data center use. Most relevant from a SQL Server perspective is the 2nd Generation Intel Scalable Processor family, aka Cascade Lake-SP. This line of 14nm processors are the successor to the existing 14nm [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/","og_site_name":"Glenn Berry","article_published_time":"2019-04-03T03:43:16+00:00","article_modified_time":"2020-01-11T20:51:58+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/cascade-lake-sp-list_thumb-1.png","type":"","width":"","height":""}],"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\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/","name":"Intel Cascade Lake-SP Processor Analysis for SQL Server - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/cascade-lake-sp-list_thumb-1.png","datePublished":"2019-04-03T03:43:16+00:00","dateModified":"2020-01-11T20:51:58+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/cascade-lake-sp-list_thumb-1.png","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/04\/cascade-lake-sp-list_thumb-1.png","width":1028,"height":398},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/intel-cascade-lake-sp-processor-analysis-for-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Intel Cascade Lake-SP Processor Analysis for SQL Server"}]},{"@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\/1551","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=1551"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1551\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}