TPC-H 100GB Sun Fire X4100, Paraccel World Record Performance and $/Perf
Tuesday Oct 30, 2007
Paraccel & Sun didn't just do one benchmark, we did it at three different sizes: TPC-H 1000GB, TPC-H 300GB, and now the 100GB details below.
in the TPC-H 1000GB blog entry we also talked about Paraccel's pricing innovations.
This benchmark result demonstrates that a shared-nothing cluster of Sun Fire X4100s achieves the best performance and, simulatenously, the best price/performance among all TPC-H@100GB submissions. Each of the 15 node in the cluster was powered by 2 dual-core 2.8GHz Opteron processors.
Specifically, the Sun Fire X4100 cluster achieved a QphH@100GB of 98,857 together with $/QphH@100GB of $2.65. The performance is more than 5 times the previously reported best performance and the price/performance is almost twice as good as the previously reported best price/performance.
Competitive Landscape TPC-H @100GB Performance:
$/QphH = TPC-H Price/Performance metric (smaller is better)
QphH = TPC-H Composite Metric (bigger is better)
| System | Socket/ Core/ Thread |
CPU Type GHz | QphH | $/ QphH |
Total $ | DBMS |
Avail | # Clust node |
| Sun Fire X4100 |
30/ 60/ 60 |
Opt 2.8GHz | 98,857 | 2.65 |
263,460.06 |
Paraccel |
10/29/07 | 15 |
| HP DL585 G2 |
4/ 8/ 8 |
Opt 2.8GHz | 19323 |
10.67 |
205,988 |
SQLS |
1/16/07 | 1 |
| Dell PE6950 |
4/ 8/ 8 | Opt 2.8GHz | 17180 |
7.64 |
131,204 |
SQLS |
12/04/06 | 1 |
| HP DL580 G4 |
4/8/8 | Xeon 3.4GHz | 17120 |
7.91 |
135,384 |
SQLS |
11/22/06 | 1 |
| Dell PE2900 |
2/ 8/ 8 | Xeon 2.66GHz | 15724 |
7.45 |
117,022 |
SQLS |
12/31/06 | 1 |
| IBM eSvr 325 |
16/ 16/ 16 | Opteron 2.0GHz | 12216 |
70.68 |
863,410 |
DB2 |
11/08/03 | 8 |
TPC-H @100GB Price-Performance:
$/QphH = TPC-H $/Perf metric (smaller better)
QphH = TPC-H Composite Metric (bigger better)
| System | Socket/ Core/ Thread |
CPU GHz | QphH | $/ QphH |
Total $ | DBMS |
Avail | # of
Clust Node |
| Sun Fire X4100 |
30/ 60/ 60 |
Opt 2.8 GHz | 98,857.0 |
2.65 |
263,460.06 |
Paraccel |
10/29/07 | 15 |
| HP ML370G5 |
1/4/4 |
Xeon 2.66 GHz | 4521 |
4.30 |
19,437 |
SQLS |
7/31/07 | 1 |
| Sun Fire X4100 |
2/ 2/ 2 |
Opt 3.0GHz | 4132 |
4.61 |
19,057 |
SybIQ |
6/23/06 | 1 |
| Sun Fire X4100M2 |
2/ 4/ 4 | Opt 3.0 GHz | 8587 |
5.29 |
45,467 |
SybIQ |
5/25/07 | 1 |
| Dell PE6950 |
4/ 8/ 8 | Opt 2.8GHz | 14923 |
5.66 |
84,387 |
SQLS |
12/04/06 |
1 |
| Dell PE6950 |
4/ 8/ 8 | Opt 2.8GHz | 17180 |
7.64 |
131,204 |
SQLS |
12/04/06 | 1 |
| HP DL580 G4 |
4/ 8/ 8 | Xeon 3.4GHz | 17120 |
7.91 |
135,384 |
SQLS |
11/22/06 | 1 |
Benchmark Description
The TPC-H benchmark is a performance benchmark established by the Transaction Processing Council (TPC) to demonstrate Data Warehousing/Decision Support Systems (DSS). TPC-H measurements are produced for customers to evaluate the performance of various DSS systems. These queries and updates are executed against a standard database under controlled conditions. Performance projections and comparisons between different TPC-H Database sizes (100GB, 300GB, 1000GB, 3000GB and 10000GB) are not allowed by the TPC.
TPC-H is a data warehousing-oriented, non-industry-specific benchmark that consists of a large number of complex queries typical of decision support applications. It also includes some insert and delete activity that is intended to simulate loading and purging data from a warehouse. TPC-H measures the combined performance of a particular database manager on a specific computer system.
The main performance metric reported by TPC-H is called the TPC-H Composite Query-per-Hour Performance Metric (QphH@SF, where SF is the number of GB of raw data, referred to as the scale factor). QphH@SF is intended to summarize the ability of the system to process queries in both single and multi user modes. The benchmark requires reporting of price/performance, which is the ratio of QphH to total HW/SW cost plus 3 years maintenance. A secondary metric is the storage efficiency, which is the ratio of total configured disk space in GB to the scale factor.
Disclosure Statement:
TPC-H @100GB Sun Fire X4100 cluster 98,857.0 QphH@100GB, $2.65/QphH@100GB, avail 10/29/07; TPC-H, QphH, $/QphH tm of Transaction Processing Performance Council (TPC). More info http://www.tpc.org.
See Also:
- Sun Fire X4100 TPC-H Executive Summary Report Acrobat PDF (68K)
- Complete Sun Fire X4100 TPC-H Full Disclosure Report Acrobat PDF (590K)
- Transaction Processing Performance Council (TPC) Home Page
- Ideas International Benchmark page
TPC-H Scale Factor 100 (SF100 - 100GB) benchmark.
| Audited Results | |||
| |
Database Size: | 100 GB (Scale Factor 100) | |
| |
TPC-H Composite: | 98,857 QphH@100GB | |
| |
$/perf: | $2.65 / QphH@100GB | |
| |
Available | Oct 29, 2007 | |
| # of Systems: | 15 x Sun Fire X4100 each X4100: 16GB memory each, 2 x 146GB (10k RPM) internal SAS each |
||
| Total # Procs: | 30 |
||
| Total # Cores: | 60 |
||
| Total # Threads: | 60 |
||
| Processor/GHz of Server: | Opteron/2.8 GHz Dual-core |
||
| Storage: | 4079 Gigabytes of disk | ||
| Database: | Paraccel Analystic Database | ||
| Operating System: | RedHat Enterprise Linux 4.4 | ||
| Total 3 year Cost: | $263,460.06 | ||
| Other Performance Metrics | |||
| |
TPC-H Power: | 70,827.4 |
|
| |
TPC-H Throughput: | 137,979.1 |
|
| |
Database Load Time | 10 minutes 42 seconds |
|
| |
Storage Ratio: | 40.08 |
|
|
|
|
|
Excellent perice perf and outstanding performance....