TPC-H Benchmark Establishes Cisco UCS C240 as the Fastest Two-socket Server for Microsoft SQL Server 2014

Cisco (UCS®) continues its tradition of performance and price/performance leadership with the announcement of a world-record TPC-H benchmark at the 1000GB Scale Factor running Microsoft SQL Server 2014. On august 20th 2014, the Cisco UCS® C240 M3 Rack Server delivered the Best Two-Socket Server Performance and Best Overall Price/Performance on the TPC-H Benchmark at the 1000GB Scale Factor.

The Cisco UCS® C240 M3 Rack Server captured the number-one spot for overall price/performance on the TPC-H benchmark at the 1000GB scale factor with a price/performance ratio of $0.73 USD per QphH@1000 GB and demonstrated 304,362 queries per hour (QphH@1000GB), making it the fastest two-socket server running Microsoft SQL Server 2014.

The TPC-H benchmark evaluates a composite performance metric (QphH@size) and a price/performance metric ($/QphH@size) that measure the performance of various decision support systems by running sets of queries against a standard database under controlled conditions. As tested, the benchmark configuration consisted of a Cisco UCS® C240 M3 Rack Server equipped with 768 GB of memory and two 2 Intel Xeon E5-2690 v2 processors. The system ran Microsoft SQL Server 2014 Enterprise Edition and Windows Server 2012 R2 Standard Edition. Check out the Performance Brief for additional information on the benchmark configuration. The detailed official benchmark disclosure report is available at the TPC Results Highlights Website.

Some of the key highlights of Cisco’s TPC-H Benchmark results are:

Best Price/Performance: The Cisco UCS® C240 M3 Rack Server captured the number-one price/performance spot on the TPC-H benchmark at the 1000-B scale factor with a price/performance ratio of $0.73 USD per QphH@1000GB. This result beats 8-socket HP ProLiant DL980 G7 running Microsoft SQL Server at 219,887 QphH and $ 1.86 USD/QphH@1000GB by 60 percent.

Best Two-Socket Server Performance for Microsoft SQL Server 2014 Cisco demonstrates 304,362 queries per hour (QphH@1000 GB), making it the fastest two-socket server running Microsoft SQL Server.

Server

Processors (Cores/Threads)

Performance

Price/Performance Ratio

Availability Date

Cisco® UCS C240 M3

2 Intel Xeon E5-2690 3.0 GHz (20 cores, 40 threads in total)

304,362 QphH@1000GB

$0.73 USD per QphH@1000GB

August 20, 2014

HP ProLiant DL980 G7

8 Intel Xeon E7-4870 2.4 GHz (80 cores, 160 threads in total)

219,887 QphH@1000GB

$1.86 USD per QphH@1000GB

August 30, 2011

This result joins the more than 90 previous world-record performance results set by Cisco UCS since it was announced five years ago. Many of these world-record results use real-world workloads, including business applications, Java middleware, database performance, high-performance computing, and virtualized and cloud computing environments. Check out the Cisco UCS Performance Benchmarks website for additional details.

For additional information on Cisco UCS and Cisco UCS solutions please visit Cisco Unified Computing & Servers web page.

Based on TPC-H Benchmark Results as of 8/22/2014.

Source: Transaction Processing Performance Council (TPC), www.tpc.org.