{"id":1546,"date":"2019-03-20T15:26:36","date_gmt":"2019-03-20T22:26:36","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1546"},"modified":"2020-08-04T17:13:10","modified_gmt":"2020-08-05T00:13:10","slug":"glenns-tech-insights-for-march-20-2019","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-march-20-2019\/","title":{"rendered":"Glenn’s Technical Insights For March 20, 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

\u00a0<\/span><\/h4>\n

AMD Processors Not Vulnerable to SPOILER CPU Exploit<\/span><\/span><\/h2>\n

A <\/span>new research paper<\/span><\/a> (PDF warning) details a new speculative execution, side-channel CPU exploit that can dramatically speed up some previously known attack types. All modern Intel processors, going back to the original <\/span>Intel Core architecture<\/span><\/a> from 2006 are vulnerable to this exploit.<\/span><\/p>\n

As the paper states:<\/span><\/p>\n

\u201cThe root cause for SPOILER is a weakness in the address speculation of Intel\u2019s proprietary implementation of the memory subsystem, which directly leaks timing behavior due to physical address conflicts. Existing spectre mitigations would therefore not interfere with SPOILER\u201d<\/span><\/p><\/blockquote>\n

Intel was informed of these findings on December 1, 2018. AMD has <\/span>released a short statement<\/span>, where <\/span>they confirm<\/span><\/a> that their products are not vulnerable to SPOILER.<\/span><\/p>\n

This is another piece of bad news for Intel. <\/span>Initial analysis indicates<\/span><\/a> that this exploit may be extremely difficult to patch at the software level. Patching at the microcode level could have a serious impact on performance.<\/span><\/p>\n

Should You Be Worried?<\/span><\/span><\/h3>\n

That is a good question. Personally, I am more worried about more primitive, well-known attack methods, especially when it comes to SQL Server. Things like <\/span>SQL injection attacks<\/span><\/a>, applications using sys admin rights, and people running seriously unpatched systems. Getting those barn doors closed should be a much higher priority for most organizations.<\/span><\/p>\n

What do you think? Were you concerned about the Spectre\/Meltdown exploits in early 2018<\/a>? Did you do any specific patching for that? I believe in digital \u201c<\/span>herd immunity<\/span><\/a>\u201d meaning that if a large percentage of the population does a good job of securing and patching their systems, it will help protect everyone. Plus, if you do a <\/span>good job protecting your system<\/span><\/a>, a higher percentage of lower skill attackers will look for an easier target.<\/span><\/p>\n

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

Intel Demonstrates 100GbE OCP NIC 3.0 Adapters<\/span><\/span><\/h2>\n

At the Open Compute Project (OCP) Global Summit 2019, Intel <\/span>showed and demonstrated<\/span><\/a> several new 100GbE adapters that use the OCP NIC 3.0 form factor. These are relatively small daughter cards that easily fit horizontally in 1U servers. Intel is a little late to the 100GbE market, behind vendors like Mellanox. Despite this, having more vendors to choose from is a good thing. Intel did a short presentation about the OCP NIC 3.0 specification at the OCP Global Summit that <\/span>you can watch here<\/span><\/a>.<\/span><\/p>\n

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

Intel Comet Lake Processors Coming Soon<\/span><\/span><\/h2>\n

With AMD\u2019s 7nm Ryzen 3000 mainstream desktop processors getting closer to release (probably announced at the <\/span>Computex 2019<\/span><\/a> show), Intel needs a competitive response for 2019. This <\/span>appears to be<\/span><\/a> a new 14nm <\/span>Comet Lake<\/span><\/a> family that may also be released in mid-2019. <\/span>These are rumored<\/span><\/a> to have up to 10 physical cores for desktop chips and up to eight physical cores for mobile chips.<\/span><\/p>\n

It is unclear at this point whether these Comet Lake processors will work in existing Intel Z390 motherboards. Intel has a pretty mixed track record when it comes to backwards compatibility for motherboards, but perhaps they are changing their ways.<\/span><\/p>\n

These processors should perform quite well on heavily multi-threaded workloads, and they will give you another alternative to jumping up to a more expensive HEDT system. This line of processors will have to compete with the AMD Ryzen 3000 processors.<\/span><\/p>\n

AMD Ryzen 3000<\/span><\/span><\/h3>\n

Current speculation<\/span><\/a> is that the 7nm AMD Ryzen 3000 series may have up to 16 physical cores in a mainstream desktop processor. The Ryzen 3000 series may also have better single-threaded performance than Comet Lake. If both of these rumors are true, it will be a huge achievement for AMD that will put a lot of pressure on Intel.<\/span><\/p>\n

\"ryzen-3000-series-release\"<\/a><\/span><\/p>\n

Figure 1: AMD Ryzen 3000 Desktop Processor<\/strong><\/span><\/b><\/p>\n

Healthy competition between Intel and AMD is good for consumers, and I hope it continues. Like many people, I was very tired of Intel rolling out annual product updates of four-core processors with very marginal performance increases. They had been doing this for the past 4-5 years, and they could get away with it because AMD just wasn\u2019t competitive. That is no longer the case.<\/span><\/p>\n

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

Intel Hires Kyle Bennet of HardOCP<\/span><\/span><\/h2>\n

Speaking of Intel changing their ways, <\/span>they have hired Kyle Bennett<\/span><\/a> (the founder of the HardOCP web site<\/a>), starting April 1, 2019. He will be the Director of Enthusiast Engagement for their Technology Leadership Marketing group.<\/span><\/p>\n

As a result, the HardOCP website will be \u201cmothballed\u201d with no new content. The HardForum will be demonetized and sold but will stay in operation. I have been a long-time reader of HardOCP, so I am sorry to see it essentially going away. This is a great opportunity for Kyle, and it is one piece of evidence that Intel is <\/span>trying to change their image<\/span><\/a>. This is <\/span>similar to Ryan Shrout<\/span><\/a> of PC Perspective <\/span>going to Intel last October<\/span><\/a> as their Chief Performance Strategist.<\/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). \u00a0 AMD Processors Not Vulnerable to SPOILER CPU Exploit A new research […]<\/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":[433],"class_list":["post-1546","post","type-post","status-publish","format-standard","hentry","category-glenns-technical-insights","category-sql-server-hardware","tag-glenns-tech-insights"],"yoast_head":"\nGlenn’s Technical Insights For March 20, 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-march-20-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 March 20, 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). \u00a0 AMD Processors Not Vulnerable to SPOILER CPU Exploit A new research […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-march-20-2019\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-20T22:26:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-05T00:13:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/03\/ryzen-3000-series-release_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=\"4 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-march-20-2019\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-march-20-2019\/\",\"name\":\"Glenn’s Technical Insights For March 20, 2019 - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-march-20-2019\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-march-20-2019\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/03\/ryzen-3000-series-release_thumb.jpg\",\"datePublished\":\"2019-03-20T22:26:36+00:00\",\"dateModified\":\"2020-08-05T00:13:10+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-march-20-2019\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-march-20-2019\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-march-20-2019\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/03\/ryzen-3000-series-release_thumb.jpg\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/03\/ryzen-3000-series-release_thumb.jpg\",\"width\":1028,\"height\":376},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-march-20-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 March 20, 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 March 20, 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-march-20-2019\/","og_locale":"en_US","og_type":"article","og_title":"Glenn’s Technical Insights For March 20, 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). \u00a0 AMD Processors Not Vulnerable to SPOILER CPU Exploit A new research […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-march-20-2019\/","og_site_name":"Glenn Berry","article_published_time":"2019-03-20T22:26:36+00:00","article_modified_time":"2020-08-05T00:13:10+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/03\/ryzen-3000-series-release_thumb.jpg","type":"","width":"","height":""}],"author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-march-20-2019\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-march-20-2019\/","name":"Glenn’s Technical Insights For March 20, 2019 - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-march-20-2019\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-march-20-2019\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/03\/ryzen-3000-series-release_thumb.jpg","datePublished":"2019-03-20T22:26:36+00:00","dateModified":"2020-08-05T00:13:10+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-march-20-2019\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-march-20-2019\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-march-20-2019\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/03\/ryzen-3000-series-release_thumb.jpg","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/03\/ryzen-3000-series-release_thumb.jpg","width":1028,"height":376},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-march-20-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 March 20, 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\/1546","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=1546"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1546\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1546"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1546"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1546"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}