Single system world record TPC-H Sun SPARC Enterprise M9000 Sun and StorageTek 2540

Thursday May 08, 2008

The Sun SPARC Enterprise M9000 configured with SPARC VI processors, Sun StorEdge 2540 Arrays, and running Solaris 10 combined with Oracle 11g achieved World Record TPC-H performance of 118,573.3 QphH@1000GB for non-clustered systems.

The TPC-H result demonstrates that the Sun SPARC Enterprise M9000 can handle the increasingly large databases required of DSS systems. Oracle delivered 13 GB/sec during the benchmark. editorial note: IBM has never proven delivered IO rates? Why does IBM only resort to quoting un-obtainable peaks?

• Why no single-system 4.7GHz or 5.0GHz Power6 on TPC-H? IBM has cluster results, this allows IBM to avoid comparisons to a single system.
• The Sun SPARC Enterprise M9000 outperformed the next best competitor non-clustered system, the HP Integrity Superdome by 69%.
• The Sun SPARC Enterprise M9000 outperformed the next best competitor non-cluster system, the HP Integrity Superdome by 18% on price/performance.
• The Sun SPARC Enterprise M9000 outperformed the clustered IBM xSeries 346 by 122%.
• The Sun SPARC Enterprise M9000 outperformed the clustered IBM xSeries 346 by 29% on price/performance.
• Sun StorageTek 2540 Array disk configuration - the 20x ST2540 configuration in this benchmark delivered sustained rates of 13.7 GB/sec and showed linear scaling from 1 to 20 arrays.
• This result demonstrates the effectiveness of Solaris 10 running Oracle 11g.

QphH = the Composite Metric (bigger is better), $/QphH = the Price/Performance metric (smaller is better)

System	Metric QphH	3 Year Total Sys $	$/QphH	QppH	QthH	CPUs	Storage Amount
Sun SPARC Enterprise M9000	118,573.3	$2,772,675	$23.38	114,725.4	122,550.2	32	34.8 TB
HP Superdome	69,999.0	$2,008,168	$28.69	90,909.1	53,898.5	32	39.7 TB
HP Superdome	68,100.6	$4,008,065	$59.00	83,041.7	55,847.7	64	40.6 TB

System	CPU	Cluster	CPU MHz	CPU	Operating System	Database	RDBMS+HW Avail date
Sun SPARC Enterprise M9000	32	N	2400	SPARC64 VI	Solaris 10	Oracle 11g	09/10/2008
HP Superdome	32	N	1600	Itanium2	Windows Server 2003	SQL Server 2005	06/18/2007
HP Superdome	64	N	1600	Itanium2	HP-UX 11.i V2	Oracle 10gR2	01/18/2006

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 SPARC Enterprise M9000 118,573.3 QphH@1000GB, $23.38/QphH@1000GB, avail 09/10/08, HP Integrity Superdome 69,999.0 QphH@1000GB, $28.69/QphH@1000GB avail 06/18/07, HP Integrity Superdome 68,100.6 QphH@1000GB, $59.00/QphH@1000GB avail 01/18/06, IBM xSeries 346 QphH@1000GB, $32.80/QphH@1000GB, avail 02/14/05, TPC-H, QphH, $/QphH tm of Transaction Processing Performance Council (TPC). More info www.tpc.org.

A 128-core (32-node 4-core) IBM Power 570 cluster (4.7 GHz, 64 chips, 256 threads) with DB2 is the best overall system at 10TB (343,551 QphH@10000GB, 32.89$/QphH, configuration available 04/15/08, Results as of 5/07/08). Note: Do not divide this result by 32 to guess at single node performance, do not compare $/perf between different GB tests, these are not permitted by TPC rules!

Results Summary

Audited Results
	Database Size:	1000 GB (Scale Factor 1000)
	TPC-H Composite:	118,573.3 QphH@1000GB
	Price/performance:	$23.38/QphH@1000GB
	Available:	09/10/2008 for Oracle (Sun HW/SW available 05/02/2008)
Number of Systems:		One Sun SPARC Enterprise M9000
Total Number Processors:		32
Processor/MHz of Server:		SPARC VI 2400 MHz / 6MB L2 Cache
Storage:		34.8 Terabytes of disk
Database:		Oracle 11g
Operating System:		Solaris 10 Update 4
Total 3 year Cost:		$2,772,675
Other Performance Metrics
	TPC-H Power:	114,725.4
	TPC-H Throughput:	122,550.2
	Database Load Time:	1:35:27

Like this post? | | | |

Posted at 06:17AM May 08, 2008 in Benchmark Issues
Tags: m9000 tpc-h