The TPC-H Benchmark

The TPC Benchmark™H (TPC-H) is a decision support benchmark. It consists of a suite of business oriented ad-hoc queries and concurrent data modifications. The queries and the data populating the database have been chosen to have broad industry-wide relevance. This benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions.

The performance metric reported by TPC-H is called the TPC-H Composite Query-per-Hour Performance Metric (QphH@Size), and reflects multiple aspects of the capability of the system to process queries. These aspects include the selected database size against which the queries are executed, the query processing power when queries are submitted by a single stream, and the query throughput when queries are submitted by multiple concurrent users. The TPC-H Price/Performance metric is expressed as $/QphH@Size.


May 2011: PowerEdge R610, R910 Ingres VectorWise results


In May 2011, Dell and Ingres published three (3) TPC-H results. Two were on the PowerEdge R910 that smashed the 300 GB and 1 TB single-node world record performance, and a third was on the PowerEdge R610 that topped the HP ProLiant DL380 G7 in performance, at half the price/performance! These were obtained with VectorWise 1.6, a breakthrough analytic database product from Ingres.

Here are how these results stack up against their nearest competitors:

Database Size System Processors/ Cores / Threads Performance (QphH@Size)
Higher is better
Price / Performance ($/QphH@Size)
Lower is better
Power / Performance (Watts / KQphH@Size)
Lower is better
Availability Date
100 GB Dell PowerEdge R610 2 x Intel Xeon X5690 (12 cores, 12 threads) 303,289 $0.16 1.28 06/30/11
HP ProLiant DL380 G7 2 x Intel Xeon X5680 (12 cores, 12 threads) 251,561 $0.38 Not reported 03/31/11
300 GB Dell PowerEdge R910 4 x Intel Xeon E7-8837 (32 cores, 32 threads) 400,931 $0.35 2.38 06/30/11
HP ProLiant DL580 G7 4 x Intel Xeon X7560 (32 cores, 64 threads) 121,345 $0.65 10.33 09/14/10
HP ProLiant DL585 G7 4 x AMD Opteron 6176 SE (48 cores, 48 threads) 107,561 $1.08 9.58 06/21/10
1,000 GB Dell PowerEdge R910 4 x Intel Xeon E7-8837 (32 cores, 32 threads) 436,788 $0.88 Not reported 06/30/11
IBM System x3850 X5 8P 8 x Intel Xeon E7-8870 (80 cores, 80 threads) 173,961 $1.37 Not reported 05/20/11
IBM Power 780 Model 9179-MHB 8 x POWER7 4.14GHz (32 cores, 128 threads) 164,747 $6.85 Not reported 03/31/11

***Table of top-performing TPC-H non-clustered performance results as of June 3 2011. For a list of full results, please visit www.tpc.org/tpch.

April 2011: PowerEdge R710 EXASOL cluster results

In April 2011, Dell and EXASOL published seven (7) TPC-H results with unparalleled performance and price/performance in a variety of database sizes: 100 GB, 300 GB, 1 TB, 3 TB, and 10 TB. These results were obtained using the Dell PowerEdge R710 running the EXASolution 4.0 database.

These results are summarized in this Dell PowerNote (1-page PDF for easy distribution).

To show how truly groundbreaking these results are, see how these results compare in performance and price/performance versus the closest competitor:

Database Size System Database Performance (QphH@Size)
Higher is better
Price/Performance ($/QphH@Size)
Lower is better
Nodes Availability Date
100 GB Dell PowerEdge R710 EXASolution 1,112,401 $0.12 8 1 Oct 2011
HP ProLiant DL380 G7 Vectorwise 251,562 $0.38 1 31 Mar 2011
300 GB Dell PowerEdge R710 EXASolution 2,180,712 $0.15 16 1 Oct 2011
CPI Phoenix IQ-201 EXASolution 547,205 $1.05 26 2 Apr 2008
1,000 GB Dell PowerEdge R710 EXASolution 4,253,937 $0.19 32 1 Oct 2011
HP ProLiant DL380 G6 ParAccel 1,316,882 $0.89 40 11 Apr 2010
3,000 GB Dell PowerEdge R710 EXASolution 5,556,993 $0.32 40 1 Oct 2011
Fujitsu PRIMERGY RX300 S4 EXASolution 1,608,920 $1.36 80 1 Aug 2008
10,000 GB Dell PowerEdge R710 EXASolution 7,128,255 $0.53 60 1 Oct 2011
IBM System p 570 IBM DB2 343,551 $32.89 1 15 Apr 2008


***Table of Top Dell EXASOL TPC-H performance results versus previous top-performing results as of April 12 2011. For a list of full results, please visit www.tpc.org/tpch.

For more information about these results, see the Dell press release. There is also a YouTube video talking about these results: