{"id":1490,"date":"2019-02-21T13:35:59","date_gmt":"2019-02-21T21:35:59","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1490"},"modified":"2019-03-04T12:53:38","modified_gmt":"2019-03-04T20:53:38","slug":"glenns-tech-insights-for-february-21-2019","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-february-21-2019\/","title":{"rendered":"Glenn&rsquo;s Tech Insights For February 21, 2019"},"content":{"rendered":"<p><em>(<span style=\"font-size: small;\">Glenn\u2019s Tech Insights\u2026<\/span><\/em><span style=\"font-size: small;\"> 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).<\/span><\/p>\n<h2><b><span style=\"font-size: medium;\"><strong>PCIe 5.0 Nears Release<\/strong><\/span><\/b><\/h2>\n<p><span style=\"font-size: small;\">On January 17, 2019, the <\/span><a href=\"http:\/\/pcisig.com\/doubling-bandwidth-under-two-years-pci-express\u00ae-base-specification-revision-50-version-09-now\"><span style=\"font-size: small;\">PCI-SIG ratified<\/span><\/a><span style=\"font-size: small;\"> version 0.9 of the PCIe 5.0 standard, with version 1.0 of the standard expected to be ratified later in Q1 of 2019. <\/span><a href=\"https:\/\/www.tomshardware.com\/news\/pcie-4.0-5.0-pci-sig-specification,38460.html\"><span style=\"font-size: small;\">PCIe 5.0 doubles the bandwidth of PCIe 4.0<\/span><\/a><span style=\"font-size: small;\">, going from 64GB\/s with sixteen lanes to 128GB\/s with sixteen lanes. The PCIe 4.0 standard also doubled the bandwidth of PCIe 3.0, which was \u201conly\u201d 32GB\/s with sixteen lanes.<\/span><\/p>\n<p><span style=\"font-size: small;\">Currently, no released AMD or Intel processors have PCIe 4.0 support, but the upcoming 7nm AMD Ryzen 3000 desktop processors and the AMD EPYC \u201cRome\u201d server processors will both have PCIe 4.0 support. The upcoming Intel Cascade Lake-SP server processors will <strong>NOT<\/strong> have PCIe 4.0 support.<\/span><\/p>\n<p><span style=\"font-size: small;\">After you have processor support for PCIe 4.0 and greater, you will need storage devices that support PCIe 4.0 and greater.<\/span><\/p>\n<p><span style=\"font-size: small;\">The <\/span><a href=\"https:\/\/www.tomshardware.com\/news\/ssd-pcie-4.0-phison-nvme,38418.html\"><span style=\"font-size: small;\">first public PCIe 4.0 NVMe SSD was demoed by Phison at CES<\/span><\/a><span style=\"font-size: small;\">. It was a Phison PS5016-E16. This SSD did 4069MB\/sec for sequential reads and 4268MB\/sec for sequential writes on CrystalDiskMark. Phison claims that the released version will have speeds up to 4.8\/4.4 GB\/s of read\/write sequential throughput. This card is due to go on sale in Q3 of 2019.<\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<h2><b><span style=\"font-size: medium;\"><strong>AMD EPYC Market Share Analysis<\/strong><\/span><\/b><\/h2>\n<p><span style=\"font-size: small;\">ServeTheHome has a <\/span><a href=\"https:\/\/www.servethehome.com\/amd-epyc-market-share-gains-in-2018-our-take\/\"><span style=\"font-size: small;\">thoughtful article<\/span><\/a><span style=\"font-size: small;\"> looking at the market share gains in the server space by the current generation AMD EPYC \u201cNaples\u201d processor. This processor was first released in mid-2017. AMD has gone from 0.8% in Q4 of 2017 to 3.2% in Q4 of 2018. That is still a small number, but I believe that market share will start to increase at a much faster rate during 2019 and 2020.<\/span><\/p>\n<p><span style=\"font-size: small;\">This is because both HPE and Dell EMC have multiple AMD EPYC systems on the market. Another reason is because the 7nm <\/span><a href=\"https:\/\/www.servethehome.com\/amd-epyc-2-rome-what-we-know-will-change-the-game\/\"><span style=\"font-size: small;\">AMD EPYC \u201cRome\u201d processors<\/span><\/a><span style=\"font-size: small;\"> are due to be released in mid-2019. I think the AMD EPYC \u201cRome\u201d processor is going to be a huge success. Rome will have PCIe 4.0 support, very high memory density, and possibly better single-threaded performance than Intel Cascade Lake-SP. This could make the AMD EPYC \u201cRome\u201d processor a better choice for SQL Server OLTP usage than Intel Cascade Lake-SP. We will see as we get closer to release, and start to see more benchmark results.<\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<h2><b><span style=\"font-size: medium;\"><strong>AMD Ryzen 3000 Series Release Date Rumors<\/strong><\/span><\/b><\/h2>\n<p><span style=\"font-size: small;\">RedGamingTech <\/span><a href=\"http:\/\/www.redgamingtech.com\/exclusive-ryzen-3000-navi-release-date-specs-intel-comet-lake\/\"><span style=\"font-size: small;\">reports that the upcoming<\/span><\/a><span style=\"font-size: small;\"> 7nm AMD Ryzen 3000 \u201cMatisse\u201d mainstream desktop processors (and a new, optional X570 chipset) are <\/span><a href=\"https:\/\/wccftech.com\/amd-ryzen-3000-cpus-x570-motherboards-and-radeon-navi-gpus-7nm-launch-rumor\/\"><span style=\"font-size: small;\">going to be released by AMD<\/span><\/a><span style=\"font-size: small;\"> on July 7, 2019. This will happen during Computex 2019. The expectation is that these AMD processors will initially have twelve physical cores. There will be a 16-core SKU being released later in the year.\u00a0 This SKU will counter the expected release of the 10nm 10-core Intel Comet Lake desktop processors.<\/span><\/p>\n<p><span style=\"font-size: small;\">It is possible that AMD will then have both a single-threaded CPU performance and a core count advantage. These processors will also sell at a lower price than the competing Intel mainstream desktop parts. This situation will probably true for at least nine-twelve months. This is not good news for Intel, and it will be interesting to see how they respond to this challenge.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>(Glenn\u2019s Tech 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). PCIe 5.0 Nears Release On January 17, 2019, the PCI-SIG ratified version [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,17],"tags":[403,424,423],"class_list":["post-1490","post","type-post","status-publish","format-standard","hentry","category-amd","category-sql-server-hardware","tag-amd-epyc","tag-amd-ryzen-3000","tag-pcie-5-0"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Glenn&rsquo;s Tech Insights For February 21, 2019 - Glenn Berry<\/title>\n<meta name=\"description\" content=\"Interesting new hardware and software developments that are generally relevant for SQL Server\" \/>\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-february-21-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 Tech Insights For February 21, 2019 - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"Interesting new hardware and software developments that are generally relevant for SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-february-21-2019\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-21T21:35:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-03-04T20:53:38+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=\"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-february-21-2019\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-february-21-2019\/\",\"name\":\"Glenn&rsquo;s Tech Insights For February 21, 2019 - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2019-02-21T21:35:59+00:00\",\"dateModified\":\"2019-03-04T20:53:38+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"description\":\"Interesting new hardware and software developments that are generally relevant for SQL Server\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-february-21-2019\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-february-21-2019\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-february-21-2019\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Glenn&rsquo;s Tech Insights For February 21, 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 Tech Insights For February 21, 2019 - Glenn Berry","description":"Interesting new hardware and software developments that are generally relevant for SQL Server","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-february-21-2019\/","og_locale":"en_US","og_type":"article","og_title":"Glenn&rsquo;s Tech Insights For February 21, 2019 - Glenn Berry","og_description":"Interesting new hardware and software developments that are generally relevant for SQL Server","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-february-21-2019\/","og_site_name":"Glenn Berry","article_published_time":"2019-02-21T21:35:59+00:00","article_modified_time":"2019-03-04T20:53:38+00:00","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-february-21-2019\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-february-21-2019\/","name":"Glenn&rsquo;s Tech Insights For February 21, 2019 - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2019-02-21T21:35:59+00:00","dateModified":"2019-03-04T20:53:38+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"description":"Interesting new hardware and software developments that are generally relevant for SQL Server","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-february-21-2019\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-february-21-2019\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-february-21-2019\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Glenn&rsquo;s Tech Insights For February 21, 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\/1490","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=1490"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1490\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1490"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1490"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}