Warning: Constant WP_TEMP_DIR already defined in /var/www/html/blogs/glenn/wp-config.php on line 94

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/blogs/glenn/wp-config.php:94) in /var/www/html/blogs/glenn/wp-includes/rest-api/class-wp-rest-server.php on line 1902
{"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’s Tech Insights For February 21, 2019"},"content":{"rendered":"

(Glenn\u2019s Tech Insights\u2026<\/span><\/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><\/p>\n

PCIe 5.0 Nears Release<\/strong><\/span><\/b><\/h2>\n

On January 17, 2019, the <\/span>PCI-SIG ratified<\/span><\/a> 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>PCIe 5.0 doubles the bandwidth of PCIe 4.0<\/span><\/a>, 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

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 NOT<\/strong> have PCIe 4.0 support.<\/span><\/p>\n

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

The <\/span>first public PCIe 4.0 NVMe SSD was demoed by Phison at CES<\/span><\/a>. 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

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

AMD EPYC Market Share Analysis<\/strong><\/span><\/b><\/h2>\n

ServeTheHome has a <\/span>thoughtful article<\/span><\/a> 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

This is because both HPE and Dell EMC have multiple AMD EPYC systems on the market. Another reason is because the 7nm <\/span>AMD EPYC \u201cRome\u201d processors<\/span><\/a> 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

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

AMD Ryzen 3000 Series Release Date Rumors<\/strong><\/span><\/b><\/h2>\n

RedGamingTech <\/span>reports that the upcoming<\/span><\/a> 7nm AMD Ryzen 3000 \u201cMatisse\u201d mainstream desktop processors (and a new, optional X570 chipset) are <\/span>going to be released by AMD<\/span><\/a> 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

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":"

(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 […]<\/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":"\nGlenn’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’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’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’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’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’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’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’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}]}}