Another Sun Fire X4500 World Record Price/Perf (codename: "Thumper")

Wednesday Oct 17, 2007

The Sun Fire X4500 system running Solaris 10 and Sybase IQ 12.6 achieved a new TPC-H Price/Performance World Record of $8.11 USD $/QphH@1000GB. (Sun Fire X4500 was code-named "Thumper")

The single Sun Fire X4500 beat the previous best Price/Performance result, the HP DL585 G2 16%, and is the only 2-socket submission at 1000GB

The total storage in this Sun configuration was 11.2TB and it still allowed it to set the price/performance record on this 1TB Benchmarks (1TB ~= SF1000 = 1000GB). Lowest total cost of ownership ($45,439) of ANY submission at 1000GB and less than 1/3rd of the cost of the HP DL585 G2 total configuration.

The TPC-H result demonstrates the Sun Fire X4500 capabilities as a database machine. Each node of the X4500 cluster delivered 1.5 GB/sec of real IO throughput for a total of 1.5 GB/sec.

The TPC-H result demonstrates the effectiveness of Solaris 10 running Sybase IQ and results on the Opteron processors. Another "warehouse in a box" result from Sun. To date, Sun is the only vendor to be able to produce "in the box" TPC-H results of any kind.

TPC-H @1000GB Performance Chart (to be added, sorry it is very late right now)

QphH = the Composite Metric (bigger is better)
$/QphH = the Price/Performance metric (smaller is better)
QppH = the Power Numerical Quantity
QthH = the Throughput Numerical Quantity
 

System	Sockets/ Cores/ Threads	CPU Type	GHz	QphH	Price/ QphH	Price in currency	DBMS	Available	Disk Data Ratio
Sun Fire X4500	2/4/4	Opteron	2.8	5604	8.11	45,439 $US	SybIQ	10/15/07	11.2
HP DL585 G2	4/8/8	Opteron	2.8	14773	9.73	143,736 $US	SQLS	04/25/07	7.8
Bull 3045	4/8/16	Itanium	1.6	12087	12.56	151,870 $US	SQLS	03/06/07	5.7
HP DL585 G1	4/4/4	Opteron	2.4	10493	13.85	145,264 $US	SQLS	03/02/06	6.4
Bull 5651	16/16/16	Itanium	1.6	17060	25.48	434,553 $US	SQLS	05/08/06	9.3
Sun Fire V490	4/8/8	US-IV+	1.5	4368	31.17	136,121 $US	SybIQ	01/05/06	2.7

Details of the Sun X4500 test

Complete benchmark results may be found at the TPC benchmark website http://www.tpc.org.

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:

Sun Fire X4500 5,604.9 QphH@1000GB, $8.11 USD $/QphH@1000GB, avail 10/15/07; HP DL585 G2, 14,773 QphH@1000GB, $9.73 USD $/QphH@1000GB, avail 4/25/07; TPC-H, QphH, $/QphH tm of Transaction Processing Performance Council (TPC). More info www.tpc.org.

Results Summary SF1000 (SF1000 = 1000GB) benchmark

Audited Results
	Database Size:	1000 GB (Scale Factor 1000)
	TPC-H Composite:	5,604.9 QphH@1000GB
	Price/performance:	$8.11 USD $/QphH@1000GB
	Available:	October 15, 2007
Number of Systems:		one Sun Fire X4500
Total Number Processors:		2
Processor/MHz of Server:		AMD Dual Core Opteron Model 290 2.8 GHz
Storage:		11.18 Terabytes of disk
Database:		Sybase IQ 12.6
Operating System:		Solaris 10
Total 3 year Cost:		$45,439.50 USD
Other Performance Metrics
	TPC-H Power:	6,446.1
	TPC-H Throughput:	4,873.5
	Database Load Time:	10 hours 5 minutes

Like this post? | | | |

Posted at 04:46PM Oct 17, 2007 in Benchmarks
Tags: opteron performance tpc-h x4500