{"id":1363,"date":"2018-04-03T14:38:44","date_gmt":"2018-04-03T21:38:44","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1363"},"modified":"2026-07-08T08:19:39","modified_gmt":"2026-07-08T15:19:39","slug":"new-tpc-e-result-for-sql-server-2017","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/new-tpc-e-result-for-sql-server-2017\/","title":{"rendered":"New TPC-E Result for SQL Server 2017"},"content":{"rendered":"

On March 31, 2018, Fujitsu submitted a new TPC-E result<\/a> for a two-socket PRIMERGY RX2540 M4 system running SQL Server 2017 Enterprise Edition on Windows Server 2016 Standard Edition. The official TPC-E Throughput score was 6,606.75, which is a new record for a two-socket system. It was barely a new record though, since Lenovo had a previous result<\/a> of 6,598.36 for a two-socket Lenovo ThinkSystem SR650 system also running SQL Server 2017 Enterprise Edition on Windows Server 2016 Standard Edition.<\/font><\/p>\n

Both systems were using the same flagship 28-core Intel Xeon Platinum 8180<\/a> processor which will give you the most overall CPU capacity per socket, along with the highest SQL Server 2017 Enterprise Edition license costs.<\/font><\/p>\n

Most organizations would be much better off with a lower core count, higher base clock speed processor from the same Intel Xeon Scalable Processor family<\/a>, which would give them better single-threaded CPU performance and much lower<\/u><\/strong> SQL Server 2017 license costs. This is especially true if you can split your database workload across two servers rather than using just one server.<\/font><\/p>\n

For example, using two, two-socket servers with the faster 12-core Intel Xeon Gold 6146 processor<\/a> rather than one, two-socket server with the flagship 28-core Intel Xeon Platinum 8180 processor<\/a> would give you about 10% more CPU capacity (not to mention twice the total memory and I\/O capacity), about 32% better single-threaded CPU performance, and also save you about $57K in SQL Server 2017 license costs.<\/font><\/p>\n

One unfortunate fact is that none of the server vendors besides Lenovo and Fujitsu have even bothered to submit a new TPC-E benchmark since February 2014. I would really like to see this change in the future, with new TPC-E submissions from vendors like Dell and HPE. I would also like to see submissions on AMD EPYC 7000 series machines, both for one and two-socket servers.<\/font><\/p>\n


<\/font><\/p>\n


<\/font><\/p>\n


<\/font><\/p>\n","protected":false},"excerpt":{"rendered":"

On March 31, 2018, Fujitsu submitted a new TPC-E result for a two-socket PRIMERGY RX2540 M4 system running SQL Server 2017 Enterprise Edition on Windows Server 2016 Standard Edition. The official TPC-E Throughput score was 6,606.75, which is a new record for a two-socket system. It was barely a new record though, since Lenovo had […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[380],"class_list":["post-1363","post","type-post","status-publish","format-standard","hentry","category-tpc-e","tag-fujitsu"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1363","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=1363"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1363\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}