{"id":1072,"date":"2016-03-10T10:33:29","date_gmt":"2016-03-10T18:33:29","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1072"},"modified":"2018-11-13T10:52:34","modified_gmt":"2018-11-13T18:52:34","slug":"new-tpc-h-benchmarks-comparing-sql-server-2016-to-sql-server-2014","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-tpc-h-benchmarks-comparing-sql-server-2016-to-sql-server-2014\/","title":{"rendered":"New TPC-H Benchmarks Comparing SQL Server 2016 to SQL Server 2014"},"content":{"rendered":"<p>There are two <a href=\"http:\/\/www.tpc.org\/tpch\/results\/tpch_last_ten_results.asp\">new TPC-H benchmark submissions<\/a> on SQL Server 2016. This is interesting, because <a href=\"http:\/\/www.tpc.org\/tpch\/results\/tpch_result_detail.asp?id=116030902\">one of these new submissions (from March 9, 2016) is from Lenovo, for a System x3850 X6<\/a> running on SQL Server 2016. <a href=\"http:\/\/www.tpc.org\/tpch\/results\/tpch_result_detail.asp?id=115050102\">Lenovo has a previous submission, from May 1, 2015<\/a>, for an identical model system running on SQL Server 2014. Both systems are running on Windows Server 2012 R2 Standard Edition. Both of these submissions are for 3000GB databases, which is very important when you are comparing score results.<\/p>\n<p>So here are the results:<\/p>\n<blockquote>\n<p>SQL Server 2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 969,504 QphH@3000GB<\/p>\n<p>SQL Server 2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 700,392 QphH@3000GB<\/p>\n<\/blockquote>\n<p>This shows a 38.4% score increase on identical hardware, which is quite impressive.<\/p>\n<p>Both of these systems have four <a href=\"https:\/\/ark.intel.com\/products\/84685\/Intel-Xeon-Processor-E7-8890-v3-45M-Cache-2_50-GHz\">Intel Xeon E7-8890 v3<\/a> (Haswell-EX) 18-core processors, and 3 TB of RAM. Both systems have Intel HT enabled. Diving into the full-disclosure report for each submission, the storage subsystem for each of these submissions is virtually identical. For both systems, the storage is mostly flash-based, with a combination of internal drives and PCIe add-in cards (AIC). No SAN used here!<\/p>\n<p>The key point is that they stored their six data files and their tempdb files across six, independent 3.2 TB PCIe flash AICs, which they describe as \u201c3200GB Enterprise Value io3 Flash Adapter\u201d. I believe that these must be <a href=\"https:\/\/www.sandisk.com\/business\/datacenter\/products\/flash-devices\/pcie-flash\/sx350\">SanDisk Fusion-io Memory SX350-3200 devices<\/a>. Lenovo also describes the storage subsystem like this in the full-disclosure report:<\/p>\n<blockquote>\n<p>The OS was stored on a RAID-1 protected array of 2 physical drives. The database files were<br \/>stored on 6 non-raided Enterprise io3 Flash drives. The log was stored on a 4-disk Raid10 array.<\/p>\n<\/blockquote>\n<p>One thing I noticed was some minor inconsistencies between the Executive Summary and the FDR about the storage subsystem details for where the transaction log file is stored on the March 9, 2016 submission. I think this is just a copy\/paste error, and log file performance is not important for this type of benchmark anyway.<\/p>\n<p>Microsoft has been publishing a <a href=\"https:\/\/blogs.msdn.microsoft.com\/psssql\/\">series of blog posts<\/a> that outline some of the performance and scalability improvements in SQL Server 2016 on the CSS Engineers blog.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are two new TPC-H benchmark submissions on SQL Server 2016. This is interesting, because one of these new submissions (from March 9, 2016) is from Lenovo, for a System x3850 X6 running on SQL Server 2016. Lenovo has a previous submission, from May 1, 2015, for an identical model system running on SQL Server [&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,156,246,279],"tags":[],"class_list":["post-1072","post","type-post","status-publish","format-standard","hentry","category-benchmarks","category-sql-server-2014","category-sql-server-2016","category-tpc-h"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>New TPC-H Benchmarks Comparing SQL Server 2016 to SQL Server 2014 - 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\/new-tpc-h-benchmarks-comparing-sql-server-2016-to-sql-server-2014\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New TPC-H Benchmarks Comparing SQL Server 2016 to SQL Server 2014 - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"There are two new TPC-H benchmark submissions on SQL Server 2016. This is interesting, because one of these new submissions (from March 9, 2016) is from Lenovo, for a System x3850 X6 running on SQL Server 2016. Lenovo has a previous submission, from May 1, 2015, for an identical model system running on SQL Server [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-tpc-h-benchmarks-comparing-sql-server-2016-to-sql-server-2014\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-10T18:33:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-13T18:52:34+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\/new-tpc-h-benchmarks-comparing-sql-server-2016-to-sql-server-2014\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-tpc-h-benchmarks-comparing-sql-server-2016-to-sql-server-2014\/\",\"name\":\"New TPC-H Benchmarks Comparing SQL Server 2016 to SQL Server 2014 - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2016-03-10T18:33:29+00:00\",\"dateModified\":\"2018-11-13T18:52:34+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-tpc-h-benchmarks-comparing-sql-server-2016-to-sql-server-2014\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-tpc-h-benchmarks-comparing-sql-server-2016-to-sql-server-2014\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-tpc-h-benchmarks-comparing-sql-server-2016-to-sql-server-2014\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New TPC-H Benchmarks Comparing SQL Server 2016 to SQL Server 2014\"}]},{\"@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":"New TPC-H Benchmarks Comparing SQL Server 2016 to SQL Server 2014 - 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\/new-tpc-h-benchmarks-comparing-sql-server-2016-to-sql-server-2014\/","og_locale":"en_US","og_type":"article","og_title":"New TPC-H Benchmarks Comparing SQL Server 2016 to SQL Server 2014 - Glenn Berry","og_description":"There are two new TPC-H benchmark submissions on SQL Server 2016. This is interesting, because one of these new submissions (from March 9, 2016) is from Lenovo, for a System x3850 X6 running on SQL Server 2016. Lenovo has a previous submission, from May 1, 2015, for an identical model system running on SQL Server [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-tpc-h-benchmarks-comparing-sql-server-2016-to-sql-server-2014\/","og_site_name":"Glenn Berry","article_published_time":"2016-03-10T18:33:29+00:00","article_modified_time":"2018-11-13T18:52:34+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\/new-tpc-h-benchmarks-comparing-sql-server-2016-to-sql-server-2014\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-tpc-h-benchmarks-comparing-sql-server-2016-to-sql-server-2014\/","name":"New TPC-H Benchmarks Comparing SQL Server 2016 to SQL Server 2014 - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2016-03-10T18:33:29+00:00","dateModified":"2018-11-13T18:52:34+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-tpc-h-benchmarks-comparing-sql-server-2016-to-sql-server-2014\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/new-tpc-h-benchmarks-comparing-sql-server-2016-to-sql-server-2014\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-tpc-h-benchmarks-comparing-sql-server-2016-to-sql-server-2014\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"New TPC-H Benchmarks Comparing SQL Server 2016 to SQL Server 2014"}]},{"@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\/1072","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=1072"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1072\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1072"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1072"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}