{"id":1723,"date":"2019-09-26T07:48:24","date_gmt":"2019-09-26T14:48:24","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1723"},"modified":"2020-08-04T17:08:24","modified_gmt":"2020-08-05T00:08:24","slug":"glenns-tech-insights-for-september-26-2019","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-26-2019\/","title":{"rendered":"Glenn&rsquo;s Technical Insights For September 26, 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 related items that I find <span style=\"font-size: small;\">interesting.<\/span><\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<h2><span style=\"font-size: medium;\"><span style=\"font-weight: bold;\">Useful Utility\/Benchmark Software Updates<\/span><\/span><\/h2>\n<p><span style=\"font-size: small;\">Samsung has released a new version of <a href=\"https:\/\/www.samsung.com\/semiconductor\/minisite\/ssd\/product\/consumer\/magician\/\" target=\"_blank\" rel=\"noopener noreferrer\">Samsung Magician<\/a>, which is now version 6.0. This release has a completely new user interface, and quite a bit of additional functionality. I have noticed that it takes longer to startup and scan your drives compared to the previous version. If you have any Samsung SSDs in your system, you really should have their Magician software, especially for obtaining and installing firmware updates.<\/span><\/p>\n<p><span style=\"font-size: small;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/09\/samsung-magician.png\"><img fetchpriority=\"high\" decoding=\"async\" style=\"display: inline; background-image: none;\" title=\"Samsung Magician\" src=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/09\/samsung-magician_thumb.png\" alt=\"Samsung Magician\" width=\"1028\" height=\"622\" border=\"0\" \/><\/a><\/span><\/p>\n<p><span style=\"font-size: small;\"><strong>Figure 1: Samsung Magician 6.0<\/strong><\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<p><span style=\"font-size: small;\">CrystalDiskMark 7 Beta 4 is available, with many new features along with additional testing and display modes. These include displaying IOPS and latency information in the main GUI.<\/span><\/p>\n<p><span style=\"font-size: small;\">You can also choose from different testing profiles, which essentially let you do similar testing compared to running Microsoft DiskSpd natively. <span style=\"font-size: small;\"><span style=\"font-size: small;\">This is going to make CDM a much more useful tool.<\/span><\/span><\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/09\/image-1.png\"><img decoding=\"async\" style=\"display: inline; background-image: none;\" title=\"image\" src=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/09\/image_thumb-1.png\" alt=\"image\" width=\"1028\" height=\"738\" border=\"0\" \/><\/a><\/p>\n<p><span style=\"font-size: small;\"><strong>Figure 2: CrystalDiskMark 7.0 Beta4 \u2013 Default Profile<\/strong><\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/09\/image-2.png\"><img decoding=\"async\" style=\"display: inline; background-image: none;\" title=\"image\" src=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/09\/image_thumb-2.png\" alt=\"image\" width=\"1028\" height=\"629\" border=\"0\" \/><\/a><\/p>\n<p><span style=\"font-size: small;\"><strong>Figure 3: CrystalDiskMark 7 Text Results<\/strong><\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<p><span style=\"font-size: small;\">This is one of the new testing profiles.<\/span><\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/09\/image-3.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: inline; background-image: none;\" title=\"image\" src=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/09\/image_thumb-3.png\" alt=\"image\" width=\"1028\" height=\"523\" border=\"0\" \/><\/a><\/p>\n<p><span style=\"font-size: small;\"><strong>Figure 4: CrystalDiskMark 7.0 Beta4 \u2013 Peak Performance + Mix Profile<\/strong><\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0<\/span><\/p>\n<h2><span style=\"font-size: medium;\"><span style=\"font-weight: bold;\">2nd Generation Intel Optane DC SSDs Coming in 2020<\/span><\/span><\/h2>\n<p><span style=\"font-size: small;\">I\u2019ve been very impressed with the <a href=\"https:\/\/www.anandtech.com\/show\/11930\/intel-optane-ssd-dc-p4800x-750gb-handson-review\" target=\"_blank\" rel=\"noopener noreferrer\">1st generation<\/a> Intel Optane SSD DC P4800X \u201cColdstream\u201d storage devices that use two-layer 3D XPoint media. They have been available since mid-2017, and they are extremely well-suited for certain types of SQL Server I\/O workloads. One prime example is write heavy tempdb workloads. <\/span><\/p>\n<p><span style=\"font-size: small;\">Now, Intel is starting to reveal more details about the 2nd generation devices in this family. These are code named \u201cAlder Stream\u201d, and they will use Barlow Pass 3D XPoint media with four layers. It is also probable that they will have PCIe 4.0 support, and a new, faster controller. They are due for release in 2020, and they will have up to double the capacity and significantly better performance than the current generation. <\/span><\/p>\n<p><span style=\"font-size: small;\">One key advantage of these devices is that they will work with legacy versions of SQL Server and legacy hardware. As long as you have PCIe 3.0 x4 hardware support and your OS supports NVMe drivers, you can use them.<\/span><\/p>\n<p><span style=\"font-size: small;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/09\/alder-stream-slide.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"display: inline; background-image: none;\" title=\"Alder Stream Slide\" src=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/09\/alder-stream-slide_thumb.jpg\" alt=\"Alder Stream Slide\" width=\"1028\" height=\"580\" border=\"0\" \/><\/a><\/span><\/p>\n<p><span style=\"font-size: small;\"><strong>Figure 5: Intel Memory and Storage Roadmap<\/strong><\/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 related items that I find interesting. [&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,399,20,435],"tags":[433],"class_list":["post-1723","post","type-post","status-publish","format-standard","hentry","category-glenns-technical-insights","category-hardware","category-intel","category-intel-optane","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 September 26, 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-september-26-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 September 26, 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 related items that I find interesting. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-26-2019\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-26T14:48:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-05T00:08:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/09\/samsung-magician_thumb.png\" \/>\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-september-26-2019\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-26-2019\/\",\"name\":\"Glenn&rsquo;s Technical Insights For September 26, 2019 - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-26-2019\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-26-2019\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/09\/samsung-magician_thumb.png\",\"datePublished\":\"2019-09-26T14:48:24+00:00\",\"dateModified\":\"2020-08-05T00:08:24+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-september-26-2019\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-26-2019\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-26-2019\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/09\/samsung-magician_thumb.png\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/09\/samsung-magician_thumb.png\",\"width\":1028,\"height\":622},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-26-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 September 26, 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 September 26, 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-september-26-2019\/","og_locale":"en_US","og_type":"article","og_title":"Glenn&rsquo;s Technical Insights For September 26, 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 related items that I find interesting. [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-26-2019\/","og_site_name":"Glenn Berry","article_published_time":"2019-09-26T14:48:24+00:00","article_modified_time":"2020-08-05T00:08:24+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/09\/samsung-magician_thumb.png","type":"","width":"","height":""}],"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-september-26-2019\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-26-2019\/","name":"Glenn&rsquo;s Technical Insights For September 26, 2019 - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-26-2019\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-26-2019\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/09\/samsung-magician_thumb.png","datePublished":"2019-09-26T14:48:24+00:00","dateModified":"2020-08-05T00:08:24+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-september-26-2019\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-26-2019\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-26-2019\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/09\/samsung-magician_thumb.png","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2019\/09\/samsung-magician_thumb.png","width":1028,"height":622},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/glenns-tech-insights-for-september-26-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 September 26, 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\/1723","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=1723"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1723\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1723"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1723"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1723"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}