SPARC Enterprise M8000 Server with Oracle Database 11g Beats HP and IBM on Non-Clustered 1 TB Scale Factor TPC-H Benchmark
(As of Friday, 3 June 2011)
Oracle delivers an outstanding TPC-H data-warehousing benchmark result at the 1000 GB scale factor, beating HP’s Superdome 2 and IBM’s Power 780 (1, 2 and 3) The result highlights the effectiveness of a complete solution built exclusively on Oracle software and hardware. The superior scalability and integration of Oracle Database 11g Release 2, running on Oracle Solaris 10, Oracle's SPARC Enterprise M8000 server and Oracle’s Sun Storage F5100 Flash arrays, delivered the best performance among competing single-system solutions from HP and IBM.
The TPC-H benchmark was established by the Transaction Processing Council (TPC) to enable customers to evaluate the performance of various Business Intelligence/Data Warehousing (BIDW) and Decision Support Systems (DSS) systems for various standard database sizes, referred to as the scale factor (SF). The benchmark measures the combined performance of a particular database manager on a specific computer system at various scale factors, including 100 GB, 300 GB, 1000 GB, 3000 GB, 10000 GB, and 30000 GB, and reports the composite TPC-H Query-per-Hour (QphH) performance metric, as well as the price/performance metric, which is the total cost of the solution, consisting of hardware, software, and three-year maintenance costs divided by the QphH.
SPARC Enterprise M8000
HP Integrity Superdome 2
IBM Power 780
Oracle 11g Release
Storage Footprint (RU)
Execution times for refresh Functions RF1and RF2 (sec)
17.4 / 18.4
39.7 / 56.0
66.7 / 52.5
Operating System (OS)
Oracle Solaris 10
HP-UX 11i v3
Red Hat EL 6
Enterprise-class SPARC Enterprise M8000 server, equipped with the latest 3 GHz SPARC64 VII+ processors and running Oracle Database 11g Release 2 on top of Solaris 10, is nearly 50 percent faster than the HP Superdome 2, while delivering 16 percent better price performance (1 and 2).
According to TPC-H rules, the price of the solution is calculated for hardware, software, and maintenance over a three-year period. This highlights Oracle's focus on the complete hardware and software solution engineered to work together.
The SPARC Enterprise M8000 server running Oracle Database 11g Release 2 outperformed the best IBM single-system result, posted by the IBM Power 780 server running Sybase IQ database software, by 27 percent (1 and 3).
The Sun Storage F5100 Flash arrays used in this benchmark delivered measured I/O performance of over 16 GB/sec. The arrays delivered outstanding performance(4) in a compact 1RU form factor than enabled reduced power consumption and helped free up valuable data center floor space. In fact, Oracle’s solution has 1/2 the storage footprint compared to IBM’s Power 780 benchmark configuration and could displace the multiple racks of storage used in HP’s Superdome 2 benchmark configuration.(5)
Oracle Solaris is a leading enterprise operating system that provides best-in-class reliability, security, and scalability and includes Solaris Volume Manager (SVM) software. SVM enables efficient and protected data placement and was used to manage all database files across four Sun Storage F5100 Flash arrays.
Moreover, mirroring was used to ensure complete data protection during benchmark execution and ACID (Atomicity, Consistency, Isolation and Durability) testing. This approach enabled efficient and protected data placement as well as allowed to execute refresh functions up to 3.8 times faster than IBM. Refresh functions insert or remove large amounts of data from the database and deliver better performance when running database software on a system with well-balanced I/O resources.
The benchmark underscores the ability of SPARC Enterprise M-series servers running Oracle Solaris to handle the increasingly large databases required for decision support and data warehousing systems. Neither IBM nor HP matched this level of performance in the 1 TB scale factor category using a single system, further highlighting the performance capabilities of multi-processor SPARC systems and flash-based storage for the most demanding enterprise applications.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. TPC Benchmark H, TPC-H, QphH are trademarks of the Transaction Performance Processing Council (TPC). More info http://www.tpc.org. Other names may be trademarks of their respective owners.
Source: Transaction Processing Performance Council (TPC) www.tpc.org. As of June 03, 2011:
SPARC Enterprise M8000 server (209,533QphH@1000GB, $10.13/QphH@1000GB, available 9/22/11. Refresh Functions RF1/RF2 execution times: 17.4s/18.4s; average 17.1s/18.8s. Oracle used Storage Redundancy Level 3 (highest) as defined by the TPC-H 2.14.0 specification.
HP Integrity Superdome 2 server -140,181 QphH@1000GB,$12.15/QphH@1000GB, available 4/26/10. Best HP TPC-H 1000GB performance (QphH).
IBM POWER 780 Model 9179-MHB server: 164,747 QphH@1000GB, $6.85 /QphH@1000GB, available 12/15/10. Best POWER7 IBM TPC-H 1000GB performance (QphH) and price/performance ($Q/phH) result. Refresh Functions RF1/RF2 execution times: 66.7s/52.5s.