{"id":27240,"date":"2019-05-16T11:00:25","date_gmt":"2019-05-16T18:00:25","guid":{"rendered":""},"modified":"2022-09-09T07:54:07","modified_gmt":"2022-09-09T14:54:07","slug":"sql-server-2017-achieves-top-tpc-benchmarks-for-oltp-and-dw-on-linux-and-windows","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/05\/16\/sql-server-2017-achieves-top-tpc-benchmarks-for-oltp-and-dw-on-linux-and-windows\/","title":{"rendered":"SQL Server 2017 achieves top TPC benchmarks for OLTP and DW on Linux and Windows"},"content":{"rendered":"

Once again, SQL Server 2017 has led the pack with three new TPC benchmarks published in April 2019, ranking SQL Server 2017 as the fastest database for online transaction processing (OLTP) and data warehouse (DW) workloads on Windows and Linux.<\/p>\n

Together with our partners, SQL Server continues to innovate with high-performing, enterprise-ready solutions that deliver unparalleled price performance<\/a>. We\u2019re pleased to share the results for the TPC-H (the industry standard for benchmarking data warehouse) performance at 3TB with HPE that currently holds the record as the industry\u2019s fastest 2-socket non-clustered solution, and 10TB with Cisco, as well as the TPC-E (the industry standard for benchmarking online transaction processing) performance at 10TB with Lenovo. Check out the results below.<\/p>\n\n\n\n\n\n
System<\/strong><\/td>\nPerformance<\/strong><\/td>\nDatabase Operating System<\/strong><\/td>\n<\/tr>\n
HPE Proliant DL380 Gen10<\/td>\n1,244,450 QphH@3000GB<\/p>\n

Learn more about price performance<\/a><\/td>\n

SQL Server 2017 Enterprise Edition<\/p>\n

SUSE Linux Enterprise Server 15<\/td>\n<\/tr>\n

Cisco UCS C480 M5 Server<\/td>\n1,651,514 QphH@10000GB<\/p>\n

Learn more about price performance<\/a><\/td>\n

SQL Server 2017 Enterprise Edition<\/p>\n

Red Hat Enterprise Linux 7.6<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The table above shows the TPC-H data warehousing results published on SQL Server 2017 with configuration (size). The table below shows the TPC-E OLTP results published on SQL Server 2017 with throughput and price\/performance ratio.<\/p>\n\n\n\n\n
System<\/strong><\/td>\nThroughput performance<\/strong><\/p>\n

Price\/tpsE<\/strong><\/td>\n

Database Operating System<\/strong><\/td>\n<\/tr>\n
Lenovo ThinkSystem SR650<\/td>\n7,012.53 tpsE<\/p>\n

Learn more about performance price\/tpsE<\/a><\/td>\n

SQL Server 2017 Enterprise Edition<\/p>\n

Windows Server 2016 Standard Edition<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

These new results for TPC-H at 3TB scale prove the superior combination of SQL Server 2017 Enterprise Edition, SUSE Linux Enterprise Server, and HPE ProLiant DL380 Gen10. The benchmark showcases the secure, resilient, and versatile 2P\/2U HPE ProLiant DL380 Gen10 as an industry-leading server for multi-workload compute, ideal for structured data analysis such as decision support for large databases.<\/p>\n

In addition, a new record for the 10TB non-clustered TPC-H benchmark has been accomplished with a winning combination of SQL Server 2017, Red Hat Linux 7.6, and Cisco UCS C480 M5 Server. Cisco\u2019s 4-socket Cascade Lake system surpassed the previous #1 10TB non-clustered result by 11.6 percent<\/a> in performance along with a cost reduction.<\/p>\n

The TPC-E results showcase SQL Server 2017 blazing the trail together with our strategic partner Lenovo. Lenovo\u2019s ThinkSystem SR650 on a 2-socket Cascade Lake system was the fastest 2-socket system when combined with SQL Server 2017 and Windows Server 2016. It surpassed the previous 2-socket Sky Lake publication by 3 percent<\/a>, and was also the best overall \u00a0price performance leader.<\/p>\n

Learn more about SQL Server 2017<\/a>.<\/p>\n

All claims in this post were made as of 5\/15\/2019.<\/p>\n

Learn more<\/h2>\n