{"id":1762,"date":"2019-11-17T14:08:45","date_gmt":"2019-11-17T22:08:45","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1762"},"modified":"2020-08-04T17:06:57","modified_gmt":"2020-08-05T00:06:57","slug":"glenns-tech-insights-for-november-17-2019","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-november-17-2019\/","title":{"rendered":"Glenn&rsquo;s Technical Insights For November 17, 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 interesting new hardware and software developments that are generally relevant for SQL Server). It also can just be technically-oriented items that I find interesting.<\/span><\/p>\n<h2><span style=\"font-size: medium;\"><span style=\"font-weight: bold;\">New Intel Processor Security Vulnerabilities Revealed<\/span><\/span><\/h2>\n<p><span style=\"font-size: small;\">Intel has disclosed two new processor security vulnerabilities, including the <a href=\"https:\/\/www.intel.com\/content\/www\/us\/en\/security-center\/advisory\/intel-sa-00270.html\">TSX Asynchronous Abort (TAA)<\/a> issue and a <a href=\"https:\/\/www.intel.com\/content\/dam\/support\/us\/en\/documents\/processors\/mitigations-jump-conditional-code-erratum.pdf\">Jump Conditional Code (JCC) Erratum<\/a>. These two issues affect most recent Intel processors, including the most recent Intel Cascade Lake-SP server processors.<\/span><\/p>\n<p><span style=\"font-size: small;\">The continued emergence of these types of issues (and the firmware and software fixes required to mitigate them) has an increasing negative effect on the performance of Intel processors.<\/span><\/p>\n<blockquote><p><span style=\"font-size: small;\"><a href=\"https:\/\/www.tomshardware.com\/news\/intel-reveals-taa-vulnerabilities-in-cascade-lake-chips-and-a-new-jcc-bug\">Intel Reveals TAA Vulnerabilities in Cascade Lake Chips and a New JCC Bug<\/a><\/span><\/p>\n<p><span style=\"font-size: small;\"><a href=\"https:\/\/www.phoronix.com\/scan.php?page=article&amp;item=zombieload-v2-taa&amp;num=1\">Zombieload V2 TAA Performance Impact Benchmarks On Cascade Lake<\/a><\/span><\/p>\n<p><span style=\"font-size: small;\"><a href=\"https:\/\/software.intel.com\/security-software-guidance\/insights\/deep-dive-intel-transactional-synchronization-extensions-intel-tsx-asynchronous-abort\">Deep Dive: Intel\u00ae Transactional Synchronization Extensions (Intel\u00ae TSX) Asynchronous Abort<\/a><\/span><\/p>\n<p><span style=\"font-size: small;\"><a href=\"https:\/\/www.phoronix.com\/scan.php?page=article&amp;item=intel-jcc-microcode&amp;num=1\">Benchmarks Of JCC Erratum: A New Intel CPU Bug With Performance Implications On Skylake Through Cascade Lake<\/a><\/span><\/p>\n<p><span style=\"font-size: small;\"><a href=\"https:\/\/www.tomshardware.com\/features\/intel-amd-most-secure-processors\">Intel vs AMD Processor Security: Who Makes the Safest CPUs?<\/a><\/span><\/p><\/blockquote>\n<p><span style=\"font-size: small;\">Microsoft\u2019s official <a href=\"https:\/\/support.microsoft.com\/en-us\/help\/4073225\/guidance-protect-sql-server-against-spectre-meltdown\">guidance for SQL Server for these types of issues is here<\/a>. Microsoft has <a href=\"https:\/\/support.microsoft.com\/en-us\/help\/4531006\/guidance-for-disabling-intel-transactional-synchronization-extensions\">released a KB article<\/a> that shows how to change a Registry setting to disable TSX (which is one way to prevent the TAA issue).<\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<h2><span style=\"font-size: medium;\"><span style=\"font-weight: bold;\">Microsoft Offers New Azure VMs Running AMD EPYC 7002 Processors<\/span><\/span><\/h2>\n<p><span style=\"font-size: small;\"><span style=\"font-size: small;\">Microsoft recently introduced <a href=\"https:\/\/azure.microsoft.com\/en-us\/pricing\/details\/virtual-machines\/windows\/#d-series\">fourth-generation D-series instances<\/a> (Da_v4 and Das_v4) which target enterprise-grade applications, relational databases, in-memory caching and analytics. These VMs use 32C\/64T AMD EPYC 7452 processors that support up to 96 vCPUs, 384GB of DDR4 RAM and 2.4TB of SSD-based temporary storage for each VM.<\/span><\/span><\/p>\n<p><span style=\"font-size: small;\">Microsoft has new fourth-generation E-series VMs (Ea_v4 and Eas_v4) that target business-critical workloads that need large amounts of memory. These VMs also run on AMD EPYC 7452 processors, supporting up to 96 vCPUs, 674GB of DDR4 RAM and 2.4TB SSD-based temporary storage for each VM.<\/span><\/p>\n<p><span style=\"font-size: small;\">The Das_v4 and the Eas_v4 series offer premium SSD managed disks, which have much better performance for I\/O intensive workloads, such as SQL Server.<\/span><\/p>\n<blockquote><p><span style=\"font-size: small;\"><a href=\"https:\/\/azure.microsoft.com\/en-us\/services\/virtual-machines\/\">Explore all Virtual Machine options<\/a><\/span><\/p><\/blockquote>\n<p><span style=\"font-size: small;\">Microsoft also has Azure NVv4 instances for virtual desktops using the 64C\/128T AMD EPYC 7742 processor and AMD Radeon Instinct MI25 GPUs. AMD had an <a href=\"https:\/\/community.amd.com\/community\/radeon-instinct-accelerators\/blog\/2019\/11\/04\/amd-technology-enables-microsoft-azure-at-ignite-2019\">announcement about this<\/a> during the Ignite conference.<\/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 interesting new hardware and software developments that are generally relevant for SQL Server). It also can just be technically-oriented items that I find interesting. New [&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-1762","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 November 17, 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-november-17-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 November 17, 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). It also can just be technically-oriented items that I find interesting. New [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-november-17-2019\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-17T22:08:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-05T00:06:57+00:00\" \/>\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=\"2 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-november-17-2019\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-november-17-2019\/\",\"name\":\"Glenn&rsquo;s Technical Insights For November 17, 2019 - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2019-11-17T22:08:45+00:00\",\"dateModified\":\"2020-08-05T00:06:57+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-november-17-2019\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-november-17-2019\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-november-17-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 November 17, 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 November 17, 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-november-17-2019\/","og_locale":"en_US","og_type":"article","og_title":"Glenn&rsquo;s Technical Insights For November 17, 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). It also can just be technically-oriented items that I find interesting. New [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-november-17-2019\/","og_site_name":"Glenn Berry","article_published_time":"2019-11-17T22:08:45+00:00","article_modified_time":"2020-08-05T00:06:57+00:00","author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-november-17-2019\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-november-17-2019\/","name":"Glenn&rsquo;s Technical Insights For November 17, 2019 - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2019-11-17T22:08:45+00:00","dateModified":"2020-08-05T00:06:57+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-november-17-2019\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-november-17-2019\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-november-17-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 November 17, 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\/1762","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=1762"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1762\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}