{"id":1009,"date":"2015-11-06T16:14:32","date_gmt":"2015-11-07T00:14:32","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1009"},"modified":"2020-05-03T16:55:45","modified_gmt":"2020-05-03T23:55:45","slug":"some-quick-comparative-crystaldiskmark-results","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/some-quick-comparative-crystaldiskmark-results\/","title":{"rendered":"Some Quick Comparative CrystalDiskMark Results"},"content":{"rendered":"<p>(New: we&#8217;ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an &#8216;expert&#8217; who ends up causing problems. Check them out <a href=\"https:\/\/kand.io\/tests\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.)<\/p>\n<p>A few weeks ago, I built a new Intel Skylake desktop system that I am going to start using as my primary workstation in the near future. I have some details about this system as described in <a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/building-a-z170-desktop-system-with-a-core-i7-6700k-skylake-processor\/\">Building a Z170 Desktop System with a Core i7-6700K Skylake Processor<\/a>. By design, this system has several different types of storage devices, so I can take advantage of the extra PCIe bandwidth in the latest <a href=\"https:\/\/www.anandtech.com\/show\/9483\/intel-skylake-review-6700k-6600k-ddr4-ddr3-ipc-6th-generation\/5\">Intel Z170 Express chipset<\/a>, and do some comparative testing.<\/p>\n<p>The latest addition to the storage family is a brand new <a href=\"https:\/\/www.anandtech.com\/show\/9702\/samsung-950-pro-ssd-review-256gb-512gb\">512GB Samsung 950 PRO M.2 PCIe NVMe<\/a> card that just arrived from Amazon yesterday afternoon. As of now, here is the available storage in this system:<\/p>\n<ol>\n<li>(2) 512GB Samsung 850 PRO SATA III SSDs in RAID 1 (using the chipset RAID controller)<\/li>\n<li>(1) 512GB Samsung 950 PRO M.2 PCIe 3.0 NVMe card in an Ultra M.2 PCIe 3.0 x4 slot<\/li>\n<li>(1) 400GB Intel 750 PCIe NVMe card in a PCIe 3.0 x16 slot<\/li>\n<li>(1) 6TB Western Digital SATA III hard drive in a SATA III port<\/li>\n<\/ol>\n<p>Since I have an NVidia GeForce GTX 960 video card in one of the PCI 3.0 x16 slots, both that slot and the PCI 3.0 x16 slot that the Intel 750 is using will go down to x8 (which means 8 lanes instead of 16 lanes). The Intel Z170 Express chipset supports 26 PCIe 3.0 lanes, so you need to think about what devices you are trying to use. This system has Windows 10 Professional installed, so it has native NVMe drivers available from Microsoft.<\/p>\n<p>I did some quick and dirty I\/O testing today with CrystalDiskMark 5.02. The two NVMe devices are both using the native Microsoft NVMe drivers from Windows 10. As you can see below, both the Samsung 950 PRO and the Intel 750 PCIe NVMe cards have tremendous sequential and random I\/O performance!<\/p>\n<table border=\"2\" width=\"600\" cellspacing=\"0\" cellpadding=\"2\">\n<tbody>\n<tr>\n<td valign=\"top\" width=\"120\"><strong>Device<\/strong><\/td>\n<td valign=\"top\" width=\"124\"><strong>Sequential Reads<\/strong><\/td>\n<td valign=\"top\" width=\"127\"><strong>Sequential Writes<\/strong><\/td>\n<td valign=\"top\" width=\"112\"><strong>Random Reads<\/strong><\/td>\n<td valign=\"top\" width=\"117\"><strong>Random Writes<\/strong><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"120\">512GB Samsung 950 Pro<\/td>\n<td valign=\"top\" width=\"124\">2595 MB\/s<\/td>\n<td valign=\"top\" width=\"127\">1526 MB\/s<\/td>\n<td valign=\"top\" width=\"112\">171755.6 IOPS<\/td>\n<td valign=\"top\" width=\"117\">104801.3 IOPS<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"120\">400GB Intel 750<\/td>\n<td valign=\"top\" width=\"124\">2369 MB\/s<\/td>\n<td valign=\"top\" width=\"127\">1081 MB\/s<\/td>\n<td valign=\"top\" width=\"112\">177938.0 IOPS<\/td>\n<td valign=\"top\" width=\"117\">151642.1 IOPS<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"120\">512GB Samsung 850 Pro<\/td>\n<td valign=\"top\" width=\"124\">1104 MB\/s<\/td>\n<td valign=\"top\" width=\"127\">532 MB\/s<\/td>\n<td valign=\"top\" width=\"112\">100420.4 IOPS<\/td>\n<td valign=\"top\" width=\"117\">60765.1 IOPS<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"120\">6TB WD Red HD<\/td>\n<td valign=\"top\" width=\"124\">176 MB\/s<\/td>\n<td valign=\"top\" width=\"127\">170 MB\/s<\/td>\n<td valign=\"top\" width=\"112\">386.7 IOPS<\/td>\n<td valign=\"top\" width=\"117\">448.2 IOPS<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Table 1: Sequential and Random Results (Queue Depth 32, 1 Thread)<\/strong><\/p>\n<p>Keep in mind that the two Samsung 850 PRO SSDs are using hardware RAID1, which seems to help their sequential read performance, and that the two NVMe devices are both using the native Microsoft NVMe drivers, which may be hurting their performance somewhat.<\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2015\/11\/image.png\"><img fetchpriority=\"high\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"image\" src=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2015\/11\/image_thumb.png\" alt=\"image\" width=\"531\" height=\"484\" border=\"0\" \/><\/a><\/p>\n<p><strong>Figure 1: 512GB Samsung 950 Pro M.2 PCIe NVMe Results<\/strong><\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2015\/11\/image1.png\"><img decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"image\" src=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2015\/11\/image_thumb1.png\" alt=\"image\" width=\"531\" height=\"484\" border=\"0\" \/><\/a><\/p>\n<p><strong>Figure 2: 400GB Intel 750 PCIe NVMe Results<\/strong><\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2015\/11\/image2.png\"><img decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"image\" src=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2015\/11\/image_thumb2.png\" alt=\"image\" width=\"531\" height=\"484\" border=\"0\" \/><\/a><\/p>\n<p><strong>Figure 3: 512GB Samsung 850 Pro SATA 3 (RAID 1) Results<\/strong><\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2015\/11\/image3.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"image\" src=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2015\/11\/image_thumb3.png\" alt=\"image\" width=\"531\" height=\"484\" border=\"0\" \/><\/a><\/p>\n<p><strong>Figure 4: 6TB Western Digital Red Results<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>(New: we&#8217;ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an &#8216;expert&#8217; who ends up causing problems. Check them out here.) A few weeks ago, I built a new Intel Skylake desktop system that I am going to start using as my primary workstation [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[121,234,17,241,260,263,34,35],"tags":[],"class_list":["post-1009","post","type-post","status-publish","format-standard","hentry","category-benchmarks","category-flash-storage","category-sql-server-hardware","category-nvme","category-samsung","category-skylake","category-ssd","category-sql-server-storage"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Some Quick Comparative CrystalDiskMark Results - 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\/some-quick-comparative-crystaldiskmark-results\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Some Quick Comparative CrystalDiskMark Results - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"(New: we&#8217;ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an &#8216;expert&#8217; who ends up causing problems. Check them out here.) A few weeks ago, I built a new Intel Skylake desktop system that I am going to start using as my primary workstation [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/some-quick-comparative-crystaldiskmark-results\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-07T00:14:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-03T23:55:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2015\/11\/image_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\/some-quick-comparative-crystaldiskmark-results\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/some-quick-comparative-crystaldiskmark-results\/\",\"name\":\"Some Quick Comparative CrystalDiskMark Results - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/some-quick-comparative-crystaldiskmark-results\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/some-quick-comparative-crystaldiskmark-results\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2015\/11\/image_thumb.png\",\"datePublished\":\"2015-11-07T00:14:32+00:00\",\"dateModified\":\"2020-05-03T23:55:45+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/some-quick-comparative-crystaldiskmark-results\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/some-quick-comparative-crystaldiskmark-results\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/some-quick-comparative-crystaldiskmark-results\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2015\/11\/image_thumb.png\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2015\/11\/image_thumb.png\",\"width\":531,\"height\":484},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/some-quick-comparative-crystaldiskmark-results\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Some Quick Comparative CrystalDiskMark Results\"}]},{\"@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":"Some Quick Comparative CrystalDiskMark Results - 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\/some-quick-comparative-crystaldiskmark-results\/","og_locale":"en_US","og_type":"article","og_title":"Some Quick Comparative CrystalDiskMark Results - Glenn Berry","og_description":"(New: we&#8217;ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an &#8216;expert&#8217; who ends up causing problems. Check them out here.) A few weeks ago, I built a new Intel Skylake desktop system that I am going to start using as my primary workstation [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/some-quick-comparative-crystaldiskmark-results\/","og_site_name":"Glenn Berry","article_published_time":"2015-11-07T00:14:32+00:00","article_modified_time":"2020-05-03T23:55:45+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2015\/11\/image_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\/some-quick-comparative-crystaldiskmark-results\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/some-quick-comparative-crystaldiskmark-results\/","name":"Some Quick Comparative CrystalDiskMark Results - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/some-quick-comparative-crystaldiskmark-results\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/some-quick-comparative-crystaldiskmark-results\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2015\/11\/image_thumb.png","datePublished":"2015-11-07T00:14:32+00:00","dateModified":"2020-05-03T23:55:45+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/some-quick-comparative-crystaldiskmark-results\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/some-quick-comparative-crystaldiskmark-results\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/some-quick-comparative-crystaldiskmark-results\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2015\/11\/image_thumb.png","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2015\/11\/image_thumb.png","width":531,"height":484},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/some-quick-comparative-crystaldiskmark-results\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Some Quick Comparative CrystalDiskMark Results"}]},{"@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\/1009","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=1009"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1009\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1009"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1009"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1009"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}