Sun/Paraccel in TPC-H 300GB World Records
Tuesday Oct 30, 2007
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@300GB submissions. Each of the 30 node in the cluster was powered by 2 dual-core 2.8GHz Opteron processors. Specifically, the Sun Fire X4100 cluster achieved a QphH@300GB of 198,578 together with $/QphH@300GB of $3.15. The performance is almost 5 times the previously reported best performance and the price/performance is more than twice as good as the previously reported best price/performance.
For other Other Innovations see: http://blogs.sun.com/bmseer/entry/innovation_setting_world_records_in
TPC-H @300GB 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 price |
DBMS |
Avail | # Clust Nodes |
| Sun Fire X4100 |
60/ 120/ 120 |
Opt 2.8GHz | 198,578 | 3.15 |
624,770 |
Paraccel |
10/29/07 | 30 |
| HP BL480c |
16/ 32/ 32 |
Opt 3.0GHz | 40411 |
18.67 |
754,232 |
Oracle |
12/18/06 | 8 |
| HP BL460c |
16/ 32/ 32 | Xeon 3.0GHz | 39614 |
12.57 |
497,869 |
Oracle |
9/15/07 |
8 |
| Dell PE6800 |
8/ 16/ 32 | Xeon 3.0GHz | 18881 |
24.37 |
460,004 |
Oracle |
4/24/06 |
2 |
| IBM eSvr 325 |
16/ 16/ 16 | Opt 2.0GHz | 13195 |
65.44 |
863,410 |
DB2 |
11/08/03 |
8 |
TPC-H @300GB Price-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 | Price/ QphH |
Price in US dollars |
DBMS |
Available | #
Clust Nodes |
| Sun Fire X4100 |
60/120/120 |
Opteron 2.8 GHz | 198578 |
3.15 |
624,770 |
Paracell |
10/29/07 | 30 |
| Sun Fire X4100M2 |
2/ 4/ 4 | Opt 3.0 GHz | 7641 |
5.89 |
45,001 |
SybIQ |
5/25/07 |
1 |
| Sun Fire X4200 |
2/ 2/ 2 |
Opt 3.0GHz | 4936 |
6.29 |
31,033 |
SybIQ |
6/23/06 | 1 |
| HP DL585 G1 |
4/ 4 /4 | Opt 2.4GHz | 12226 |
11.71 |
143,041 |
SQLS |
1/26/06 | 1 |
| HP BL460c |
16/ 32/ 32 | xeon 3.0GHz | 39614 |
12.57 |
497,869 |
Oracle |
9/15/07 | 8 |
| HP DL585 G2 |
4/ 8/ 8 | Opt 2.8GHz | 18299 |
13.67 |
250,057 |
SQLS |
4/19/07 |
1 |
| IBM x3650 |
2/ 4/ 4 | Xeon 3.0GHz | 10165 |
15.40 |
156,535 |
DB2 |
10/06/06 |
1 |
| Dell 6800 |
8/ 8/ 8 | Xeon 3.33GHz | 11743 |
21.84 |
256,383 |
Oracle |
1/08/06 | 2 |
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 @300GB Sun Fire X4100 cluster 198,578.1 QphH@300GB, $3.15/QphH@300GB, 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
Results Summary TPC-H SF300 - 300GB benchmark
| Audited Results | |||
| |
Database Size: | 300 GB (Scale Factor 300) | |
| |
TPC-H Composite: | 198,578 QphH@300GB | |
| |
Price/performance: | $3.15 / QphH@300GB | |
| |
Available | Oct 29, 2007 | |
| Number of Systems: | 30 x Sun Fire X4100 each X4100: 16GB memory each, 2 x 146GB (10k RPM) internal SAS each |
||
| Total Number Processors: | 60 |
||
| Total Number Cores: | 120 |
||
| Total Number Threads: | 120 |
||
| Processor/GHz of Server: | Opteron/2.8 GHz Dual-core |
||
| Storage: | 8158 Gigabytes of disk | ||
| Database: | Paraccel Analystic Database | ||
| Operating System: | RedHat Enterprise Linux 4.4 | ||
| Total 3 year Cost: | $624,770.12 | ||
| Other Performance Metrics | |||
| |
TPC-H Power: | 145,219.3 |
|
| |
TPC-H Throughput: | 271,542.9 |
|
| |
Database Load Time | 15 minutes 5 seconds |
|
| |
Storage Ratio: | 27.19 |
|
|
|
|
|
