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. 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

Honestly, I am pretty underwhelmed by Cascade Lake-SP so far, at least for SQL Server. It is 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

<\/font><\/p>\n

<\/font><\/p>\n

<\/font><\/p>\n

<\/font><\/p>\n

<\/font><\/p>\n

<\/font><\/p>\n

<\/font><\/p>\n

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

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 […]<\/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":"\n