SPARC Enterprise M9000 with Oracle Database 11g Delivers World Record Single Server TPC-H @3000GB Result
By Brian Whitney on Mar 25, 2011
Oracle's SPARC Enterprise M9000 server delivers single-system TPC-H @3000GB world record performance. The SPARC Enterprise M9000 server along with Oracle's Sun Storage 6180 arrays and running Oracle Database 11g Release 2 on the Oracle Solaris operating system proves the power of Oracle's integrated solution.
The SPARC Enterprise M9000 server configured with SPARC64 VII+ processors, Sun Storage 6180 arrays and running Oracle Solaris 10 combined with Oracle Database 11g Release 2 achieved World Record TPC-H performance of 386,478.3 QphH@3000GB for non-clustered systems.
The SPARC Enterprise M9000 server running the Oracle Database 11g Release 2 software is 2.5 times faster than the IBM p595 (POWER6) server which ran with Sybase IQ v.15.1 database software.
The SPARC Enterprise M9000 server is 3.4 times faster than the IBM p595 server for data loading.
The SPARC Enterprise M9000 server is 3.5 times faster than the IBM p595 server for Refresh Function.
The SPARC Enterprise M9000 server configured with Sun Storage 6180 arrays shows linear scaling up to the maximum delivered IO performance of 48.3 GB/sec as measured by vdbench.
The SPARC Enterprise M9000 server running the Oracle Database 11g Release 2 software is 2.4 times faster than the HP ProLiant DL980 server which used Microsoft SQL Server 2008 R2 Enterprise Edition software.
The SPARC Enterprise M9000 server is 2.9 times faster than the HP ProLiant DL980 server for data loading.
The SPARC Enterprise M9000 server is 4 times faster than the HP ProLiant DL980 server for Refresh Function.
A 1.94x improvement was delivered by the SPARC Enterprise M9000 server result using 64 SPARC64 VII+ processors compared to the previous Sun SPARC Enterprise M9000 server result which used 32 SPARC64 VII processes.
Oracle's TPC-H result shows that the SPARC Enterprise M9000 server can handle the increasingly large databases required of DSS systems. The IO rate as measured by the Oracle database is over 40 GB/sec.
Oracle used Storage Redundancy Level 3 as defined by the TPC-H 2.14.0 specification which is the highest level.
TPC-H @3000GB, Non-Clustered Systems
|SPARC Enterprise M9000
3 GHz SPARC64 VII+
|Sun SPARC Enterprise M9000
2.88 GHz SPARC64 VII
|HP ProLiant DL980 G7
2.27 GHz Intel Xeon X7560
|IBM Power 595
5.0 GHz POWER6
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
Complete benchmark results found at the TPC benchmark website http://www.tpc.org.
Configuration Summary and Results
1024 GB memory
4 x internal SAS (4 x 146 GB)
Oracle Database 11g Release 2 Enterprise Edition
|Database Size:||3000 GB (Scale Factor 3000)|
|TPC-H Composite:||386,478.3 QphH@3000GB|
|Total 3 year Cost:||$7,030,009|
|Database Load Time:||2:59:01|
Benchmark DescriptionThe 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.
Key Points and Best Practices
- The Sun Storage 6180 array showed linear scalability of 48.3 GB/sec Sequential Read with thirty-two Sun Storage 6180 arrays. Scaling could continue if there are more arrays available.
- Oracle Solaris 10 9/10 required very little system tuning.
- The optimal Sun Storage 6180 arrays configuration for the
benchmark was to set up 1 disk per volume instead of multiple disks per
volume and let Oracle Oracle Automatic Storage Management (ASM) mirror.
Presenting as many volumes as possible to Oracle database gave the
highest scan rate.
- The storage was managed by ASM with 4 MB stripe size.
1 MB is the default stripe size but 4 MB works better
for large databases.
- All the Oracle database files,
except TEMP tablespace, were mirrored
under ASM. 16 x Sun Storage 6180 arrays
(256 disks) were mirrored to another 16 x Sun Storage 6180
arrays using ASM. IO performance was good and balanced across all the
disks. With the ASM mirror the benchmark passed the ACID (Atomicity,
Consistency, Isolation and Durablity) test.
- Oracle database tables were 256-way
partitioned. The parallel degree for
each table was set to 256 to match the number of
available cores. This
setting worked the best for performance.
- Oracle Database 11g Release 2 feature Automatic Parallel Degree Policy was set to AUTO for the benchmark. This enabled automatic degree of parallelism, statement queuing and in-memory parallel execution.
- Oracle Press Release
- Benchmark Result on oracle.com
- vdbench tool
- Transaction Processing Performance Council (TPC) Home Page
- Ideas International Benchmark Page
- SPARC Enterprise M9000 Server
Oracle Database 11g Release 2 Enterprise Edition
Sun Storage 6180 Array
SPARC Enterprise M9000 386,478.3 QphH@3000GB, $18.19/QphH@3000GB, avail 09/22/11, IBM Power 595 QphH@3000GB, 156,537.3 QphH@3000GB, $20.60/QphH@3000GB, avail 11/24/09, HP ProLiant DL980 G7 162,601.7 QphH@3000GB, $2.68/QphH@3000GB avail 10/13/10, TPC-H, QphH, $/QphH tm of Transaction Processing Performance Council (TPC). More info www.tpc.org.