You may recall that just last year, Dell set database benchmark records with Vectorwise using the PowerEdge R910.

Today, I’d like to announce two new TPC-H world record benchmarks using the Dell PowerEdge R720 and Actian Vectorwise.  These results set records for both benchmark performance and price/performance for 100GB and 300GB database sizes!

TPC-H measures decision support benchmark performance.  Its primary metrics are performance, measured in Queries Per Hour (QphH), and the cost to achieve that performance, measured in $/QphH.

Here’s how the first R720 result stacks up against the other top 100GB single-node results:

A couple of important points:

  • The PowerEdge R720 has 21% higher performance and lower overall system cost than the Cisco UCS C250 M2.  Digging into the results, it’s important to note that Cisco used their proprietary chipset and 48 DIMMs to achieve their result, while our result only used half the number of DIMMs and a standard chipset
  • The PowerEdge R720 has 60% higher performance than the ProLiant DL380 G7, at a fraction (1/3) of its price/performance!

How does the R720 handle larger databases?  Well, with a 300GB database, the dual-socket R720 surpasses HP’s top results, both of which are 4-socket results!

As you can see, the PowerEdge R720 achieved over 3X the performance of the DL580 G7 and DL585 G7; it also only used a fraction of the memory DIMMs (24 DIMMs vs. 64 for the DL580, and 48 in the DL585)!

Are you using (or considering) 12th Generation Dell PowerEdge servers in your database environment?  Let us know in the comments!

 Comparison 1: TPC-H 100GB single-node results

System

Performance
(QphH @ 100GB)

Price/Performance
($/QphH @ 100GB)

System Availability

Dell PowerEdge R720

403,230

$0.12 USD

5/8/12

Cisco UCS C250 M2

332,481

$0.15 USD

2/14/12

Dell PowerEdge R610

303,289

$0.16 USD

6/30/11

HP ProLiant DL380 G7

251,561

$0.38 USD

3/31/11

 Comparison 2: TPC-H 300GB single-node results

System

Performance (QphH @ 300GB)

Price/Performance
($/QphH @ 300GB)

System Availability

Dell PowerEdge R720

410,594

$0.28 USD

5/8/12

HP ProLiant DL580 G7

121,345

$0.65 USD

9/14/10

HP ProLiant DL585 G7

107,561

$1.08 USD

6/21/10

 All references above are Non-Clustered Version 2 Results and current as of 5/14/12.

TPC and the benchmark name TPC-H are registered trademarks of the Transaction Processing Performance Council. The TPC believes that comparisons of TPC-H results measured against different database sizes are misleading and discourages such comparisons.