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":805,"date":"2013-06-19T07:39:52","date_gmt":"2013-06-19T14:39:52","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=805"},"modified":"2018-10-09T09:08:25","modified_gmt":"2018-10-09T16:08:25","slug":"new-amd-based-tpc-e-benchmark-result","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-amd-based-tpc-e-benchmark-result\/","title":{"rendered":"New AMD-based TPC-E Benchmark Result"},"content":{"rendered":"

HP recently submitted a TPC-E benchmark result for a two-socket HP ProLiant DL385p Gen 8 system<\/a> that is using two 2.8GHz AMD Opteron 6386SE, 16-core processors. This system had a score of 1416.37 TpsE<\/strong>, which does not sound too bad until you compare it to a very similar two-socket HP ProLiant DL380p Gen 8 system<\/a> that is using two 2.9GHz Intel Xeon E5-2690, eight-core processors. The Intel system had a score of 1881.76 TpsE<\/strong>, which is 32.8% higher than the AMD-based system. That is pretty significant just from a pure OLTP performance perspective, but the story gets even worse when you look at the per-physical core performance and the SQL Server 2012 Enterprise Edition licensing cost differences for the two systems, as shown in Figure 1.<\/p>\n\n\n\n\n\n
Processor<\/td>\nTPC-E Score<\/td>\nScore\/Physical Core<\/td>\nSQL 2012 License Cost<\/td>\n<\/tr>\n
Intel Xeon E5-2690<\/td>\n1881.76<\/td>\n117.61<\/td>\n$109,952<\/td>\n<\/tr>\n
AMD Opteron 6386SE<\/td>\n1416.37<\/td>\n44.26<\/td>\n$164,928<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Figure 1: Comparative TPC-E Metrics and SQL Server 2012 License Costs<\/strong><\/p>\n

The DL385p Gen 8 system has 32 physical cores (that all must be licensed with $6872.00 SQL Server 2012 Enterprise Edition core licenses). The SQL Server 2012 Core Factor Table gives a 25% discount for modern AMD processors that have more than six physical cores. You can download it here (PDF warning), although Microsoft has not updated it to include the newer Opteron 6300 series of processors, which is probably just an oversight by Microsoft.<\/p>\n

The DL 380p Gen 8 system only has 16 physical cores that must be licensed (hyper-threading is not taken into account for licensing on physical servers), so the SQL Server 2012 Enterprise Edition licensing cost is significantly less. Paying about 50% more to get about 33% less performance does not seem like a compelling value proposition!<\/p>\n

I really wish that AMD was able to present some viable competition in this area for Intel, but I just don\u2019t see that happening based on the currently available roadmaps from both companies. Lacking any real competition on the performance front, there is less incentive for Intel to meet their release schedules for new processor microarchitectures.<\/p>\n","protected":false},"excerpt":{"rendered":"

HP recently submitted a TPC-E benchmark result for a two-socket HP ProLiant DL385p Gen 8 system that is using two 2.8GHz AMD Opteron 6386SE, 16-core processors. This system had a score of 1416.37 TpsE, which does not sound too bad until you compare it to a very similar two-socket HP ProLiant DL380p Gen 8 system […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,121,31,37],"tags":[314,317],"class_list":["post-805","post","type-post","status-publish","format-standard","hentry","category-amd","category-benchmarks","category-sql-server-2012","category-tpc-e","tag-amd","tag-intel"],"yoast_head":"\nNew AMD-based TPC-E Benchmark Result - Glenn Berry<\/title>\n<meta name=\"description\" content=\"Describes new AMD-based OLTP benchmark result and compares to a similar Intel system result\" \/>\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-amd-based-tpc-e-benchmark-result\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New AMD-based TPC-E Benchmark Result - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"Describes new AMD-based OLTP benchmark result and compares to a similar Intel system result\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-amd-based-tpc-e-benchmark-result\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2013-06-19T14:39:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-10-09T16:08:25+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-amd-based-tpc-e-benchmark-result\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-amd-based-tpc-e-benchmark-result\/\",\"name\":\"New AMD-based TPC-E Benchmark Result - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2013-06-19T14:39:52+00:00\",\"dateModified\":\"2018-10-09T16:08:25+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"description\":\"Describes new AMD-based OLTP benchmark result and compares to a similar Intel system result\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-amd-based-tpc-e-benchmark-result\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-amd-based-tpc-e-benchmark-result\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-amd-based-tpc-e-benchmark-result\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New AMD-based TPC-E Benchmark Result\"}]},{\"@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 AMD-based TPC-E Benchmark Result - Glenn Berry","description":"Describes new AMD-based OLTP benchmark result and compares to a similar Intel system result","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-amd-based-tpc-e-benchmark-result\/","og_locale":"en_US","og_type":"article","og_title":"New AMD-based TPC-E Benchmark Result - Glenn Berry","og_description":"Describes new AMD-based OLTP benchmark result and compares to a similar Intel system result","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-amd-based-tpc-e-benchmark-result\/","og_site_name":"Glenn Berry","article_published_time":"2013-06-19T14:39:52+00:00","article_modified_time":"2018-10-09T16:08:25+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-amd-based-tpc-e-benchmark-result\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-amd-based-tpc-e-benchmark-result\/","name":"New AMD-based TPC-E Benchmark Result - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2013-06-19T14:39:52+00:00","dateModified":"2018-10-09T16:08:25+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"description":"Describes new AMD-based OLTP benchmark result and compares to a similar Intel system result","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-amd-based-tpc-e-benchmark-result\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/new-amd-based-tpc-e-benchmark-result\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-amd-based-tpc-e-benchmark-result\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"New AMD-based TPC-E Benchmark Result"}]},{"@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\/805","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=805"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/805\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=805"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=805"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}