{"id":466,"date":"2012-11-29T11:47:39","date_gmt":"2012-11-29T11:47:39","guid":{"rendered":"\/blogs\/glenn\/post\/Two-New-TPC-E-Submissions-for-SQL-Server-2012.aspx"},"modified":"2018-11-13T10:51:45","modified_gmt":"2018-11-13T18:51:45","slug":"two-new-tpc-e-submissions-for-sql-server-2012","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/two-new-tpc-e-submissions-for-sql-server-2012\/","title":{"rendered":"Two New TPC-E Submissions for SQL Server 2012"},"content":{"rendered":"

Just when I was not looking, two new official TPC-E results have been posted<\/a> in the last week. IBM has a 3218.46 TPC-E score<\/a> for an IBM System x3850 X5 that has four Intel Xeon E7-4870 processors<\/a>, while HP has an 1881.76 TPC-E score<\/a> for an HP ProLiant DL380p Gen8 system with two Intel Xeon E5-2690 processors<\/a>.<\/p>\n

What is notable about this is that the 3218.46 score for a four-socket Xeon E7-4870 system is significantly higher than we have seen for similar four-socket Xeon E7-4870 systems in the past. An especially good comparison is between an IBM System x3850 X5 that was submitted on June 27, 2011<\/a> and this latest result for an IBM System x3850 X5 system that was submitted on November 28, 2012<\/a>.\u00a0 As you can see in Table 1, the newer submission for the same model server has a 12.4% higher score<\/em><\/strong> than the older submission. This is for the exact same model server, with the exact same number and model of processors.\u00a0 The first big difference that jumps out is that the newer submission is running SQL Server 2012 Enterprise Edition on top of Windows Server 2012 Standard Edition, while the older submission is running SQL Server 2008 R2 Enterprise Edition on top of Windows Server 2008 R2 Enterprise Edition.<\/p>\n\n\n\n\n\n
Date<\/strong><\/td>\nModel<\/strong><\/td>\nProcessor<\/strong><\/td>\nOperating System<\/strong><\/td>\nSQL Server Version\/Edition<\/strong><\/td>\nTPC-E Score<\/strong><\/td>\n<\/tr>\n
6\/27\/2011<\/td>\nSystem x3850 X5<\/td>\nXeon E7-4870<\/td>\nWindows Server 2008 R2 Enterprise<\/td>\nSQL Server 2008 R2 Enterprise<\/td>\n2862.61<\/td>\n<\/tr>\n
11\/28\/2012<\/td>\nSystem x3850 X5<\/td>\nXeon E7-4870<\/td>\nWindows Server 2012 Standard<\/td>\nSQL Server 2012 Enterprise<\/td>\n3218.46<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Table 1: Comparing Two IBM System x3850 X5 TPC-E Submissions<\/strong><\/p>\n

Could this 12.4% performance jump be simply due to the newer operating system and the newer version of SQL Server?\u00a0 It is very possible that there were some low level improvements in Windows Server 2012 that work in conjunction with SQL Server 2012 to improve performance (similar to what we saw with Windows Server 2008 R2 combined with SQL Server 2008 R2). With Windows Server 2008 R2, Microsoft did some low-level optimizations so that they could scale from 64 logical processors to 256 logical processors. This work also benefitted smaller systems with fewer logical processors.\u00a0 I think it is likely that some similar work was done with Windows Server 2012, so that it could scale from 256 logical processors to 640 logical processors, so that might explain some of the performance increase. I have some questions in to some of my friends at Microsoft, trying to get some more detailed information about this possibility.<\/p>\n

It is also possible that there were improvements in SQL Server 2012 all by itself that contributed to the performance increase. Another possibility is that the TPC-E team at IBM just did a much better job on this newer system. If you dive deeper into the two submissions, you will notice some other differences in the hardware and the environment for the test.\u00a0 The newer submission is a system with 2048GB of RAM and (126) 200GB SAS SSDs for database storage, with a 13.3TB initial database size, while the older submission is a system with 1024GB of RAM and (90) 200GB SAS SSDs for database storage, with a 11.6TB initial database size. As long as you have sufficient I\/O capacity to drive the TPC-E workload, the TPC-E score is usually limited by processor performance, so I don\u2019t really think that the RAM and I\/O differences are that significant here.<\/p>\n

What do you think about this?\u00a0 I would love to hear your opinions and comments!<\/p>\n","protected":false},"excerpt":{"rendered":"

Just when I was not looking, two new official TPC-E results have been posted in the last week. IBM has a 3218.46 TPC-E score for an IBM System x3850 X5 that has four Intel Xeon E7-4870 processors, while HP has an 1881.76 TPC-E score for an HP ProLiant DL380p Gen8 system with two Intel Xeon […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,20,24,25,31,37,38,39],"tags":[51,323,328],"class_list":["post-466","post","type-post","status-publish","format-standard","hentry","category-sql-server-hardware","category-intel","category-processors","category-sandy-bridge-ep","category-sql-server-2012","category-tpc-e","category-westmere-ex","category-windows-server-2012","tag-oltp","tag-sql-server-2012","tag-tpc-e"],"yoast_head":"\nTwo New TPC-E Submissions for SQL Server 2012 - Glenn Berry<\/title>\n<meta name=\"description\" content=\"Information about new TPC-E submissions for SQL Server 2012\" \/>\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\/two-new-tpc-e-submissions-for-sql-server-2012\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Two New TPC-E Submissions for SQL Server 2012 - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"Information about new TPC-E submissions for SQL Server 2012\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/two-new-tpc-e-submissions-for-sql-server-2012\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2012-11-29T11:47:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-13T18:51:45+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\/two-new-tpc-e-submissions-for-sql-server-2012\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/two-new-tpc-e-submissions-for-sql-server-2012\/\",\"name\":\"Two New TPC-E Submissions for SQL Server 2012 - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2012-11-29T11:47:39+00:00\",\"dateModified\":\"2018-11-13T18:51:45+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"description\":\"Information about new TPC-E submissions for SQL Server 2012\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/two-new-tpc-e-submissions-for-sql-server-2012\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/two-new-tpc-e-submissions-for-sql-server-2012\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/two-new-tpc-e-submissions-for-sql-server-2012\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Two New TPC-E Submissions for SQL Server 2012\"}]},{\"@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":"Two New TPC-E Submissions for SQL Server 2012 - Glenn Berry","description":"Information about new TPC-E submissions for SQL Server 2012","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\/two-new-tpc-e-submissions-for-sql-server-2012\/","og_locale":"en_US","og_type":"article","og_title":"Two New TPC-E Submissions for SQL Server 2012 - Glenn Berry","og_description":"Information about new TPC-E submissions for SQL Server 2012","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/two-new-tpc-e-submissions-for-sql-server-2012\/","og_site_name":"Glenn Berry","article_published_time":"2012-11-29T11:47:39+00:00","article_modified_time":"2018-11-13T18:51:45+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\/two-new-tpc-e-submissions-for-sql-server-2012\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/two-new-tpc-e-submissions-for-sql-server-2012\/","name":"Two New TPC-E Submissions for SQL Server 2012 - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2012-11-29T11:47:39+00:00","dateModified":"2018-11-13T18:51:45+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"description":"Information about new TPC-E submissions for SQL Server 2012","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/two-new-tpc-e-submissions-for-sql-server-2012\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/two-new-tpc-e-submissions-for-sql-server-2012\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/two-new-tpc-e-submissions-for-sql-server-2012\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Two New TPC-E Submissions for SQL Server 2012"}]},{"@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\/466","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=466"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/466\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}