The SAS ETL (Extract, Transform and Load) benchmark simulates an operation typical of large scale data integration operations for data warehousing. It reads in a multi terabyte data set, performs data transformation, and loads it into SAS Intelligent Storage (datasets or SPDS). Complexity can be increased by adding in data validation, Star Schema Builds (with dimension table builds and lookups), as well as index creation.
The Sun Fire E25K server achieved a World Record throughput of 5.90 TB per hour for the Bulkload with Data Validation into Text. The Sun E25K server was configured with 72 1.95 GHz processors and 20 ST6140 storage arrays, running Solaris 10 11/06, Sun StorageTek QFS 4.5, SAS Enterprise Data Integration Server 9.1.3 SP4.
The Sun Fire E25K server has achieved new world-record results on the TPC-H data warehousing benchmark at
the 3 Terabyte scale factor for both overall performance and single-system price/performance. The TPC-H benchmark was established
by the Transaction Processing Council (TPC) to demonstrate the performance of Business Intelligence/Data Warehousing (BIDW) and
Decision Support Systems (DSS). TPC-H is non-industry-specific and allows customers to evaluate the performance of various DSS systems
in conjunction with a 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 the scale factors including 100GB, 300GB, 1000GB and 3000GB, and reports
the composite TPC-H Query-per-Hour (QphH) performance metric, as well as the price/performance, which is the ratio of total cost of solution,
consisting of hardware, software and three year maintenance costs to the QphH.
The Sun Fire E25K server has achieved new world-record results for overall performance of 114,713.7 QphH@3000GB and single-system price/performanc
of $36.68/QphH@3000GB. The TPC-H benchmark was run on a Sun Fire E25K with 72 1.8 GHz UltraSPARC IV+ processors, configured with Sun StorageTek
6140 arrays, running Solaris 10 and Oracle Database 10g with Automatic Storage Management. The benchmark measures high-load multiple query throughput
as well as single query performance.
The Sun Fire E25K server outperformed the best competitor non-cluster system, the IBM p5-595, with 100,512.3 QphH@3000GB published 03/01/06, by 14%
and had the best price/performance of the top six performing systems.
The Sun Fire E25K server with 72 1.95 GHz processors achieved 1,657,274 SPECjbb2005 bops, 23,018 SPECjbb2005 bops/JVM. This beats the latest result of 1,251,024 SPECjbb2005 bops and 39,095 SPECjbb2005 bops/JVM for the Fujitsu PRIMEPOWER 2500 server equipped with 2.08 GHz SPARC64 V processors by 32% and is over 5.1 times faster than the fastest IBM POWER5+ p5 570 server result (1.9GHz 16 cores) of 326,651 bops.
The Sun Fire E25K server configured with 1.8 GHz US-IV+ processors and Sun StorEdge 3510FC arrays set a new
World Record for the LHS BSCS iX billing and customer care system benchmark, achieving 1,264,490 invoices/hr, a speedup of
over 12% compared to the previous Sun Fire E25K server World Record of 1,125,179 invoices/hr set with 1.5 GHz US-IV+ processors.
The Sun Fire E25K with 1.8 GHz US-IV+ processors outperformed the next best competitor system, the HP Integrity Superdome system
by over 26%. [6]
The Sun Fire E25K with 72 UltraSPARC IV+ 1.8GHz processors delivered a peak SPECint_rate2000 of 1,644.
This improved the performance over similar Sun Fire E25K's with UltraSPARC IV 1.2GHz and UltraSPARC IV+ 1.5GHz processors
by 93% and 13% respectively. It also beat the best IBM result, the recently announced IBM System p5 595 (2300 MHz, 64 CPU)
by 9%. [5]
The Sun Fire E25K with UltraSPARC IV+ technology achieved World Record performance on the SPECjbb2005 benchmark,
beating the recently announced result from Fujitsu for the PRIMEPOWER 2500 with SPARC64 V, at a much lower acquisition cost. [4]
The Sun Fire E25K server running Solaris 10 combined with Oracle 10g achieved World Record TPC-H
performance, outperforming IBM's p5 595 by 5% on the composite metric and by 20% on the throughput metric. The Sun
Fire E25K system also outperformed HP's Integrity Superdome by 47%. [3]
The Sun Fire E25K server running Solaris 10 combined with Oracle 10g achieved World Record
TPC-H performance of 108,099.7 QphH@10000GB and World Record price/performance of $53.80/QphH@10000GB. This
result outperforms IBM's p5 575 8-way cluster result by 4% and HP's Superdome 2-way cluster result by 25%. [2]
The UltraSPARC IV / Solaris platform has demonstrated another World Record on the Sun Fire E25K
server using Informatica's PowerCenter 7.1.2 ETL (7). A combination of the Sun Fire E25K server, Sun StorEdge 3510
and Solaris 10 achieved a one-terabyte ETL (extract, transform and load) in under 37 minutes faster than any previously
published data integration benchmark result. The fastest load time for one terabyte of data was a record-setting 36.4 minutes
or 22.9 gigabytes per hour per CPU using a 72-processor server configuration. In addition, near-linear scalability was
exhibited across all processor configurations demonstrating PowerCen. [1]
|
The Standard Performance Evaluation Corporation (SPEC) is a non-profit corporation formed to establish, maintain and endorse a standardized set of relevant benchmarks that can be applied to the newest generation of high-performance computers. SPEC develops suites of benchmarks and also reviews and publishes submitted results from their member organizations and other benchmark licensees.
|
[1] Informatica ETL Sun Fire E25K 44.6 min, 72 1.2 GHz UltraSPARC IV, StorEdge 3510, Solaris 10, Informatica PowerCenter 7, Oracle 9i, TPC-H dbgen. More info www.informatica.com. TPC-H, reg tm Transaction Processing Performance Council (TPC). More info www.tpc.org".
[2] Sun Fire E25K 108,099.7 QphH@10000GB, $53.80/QphH@10000GB, avail 01/23/06, IBM eServer p5 575 cluster 104,100.1 QphH@10000GB, $61.17/QphH@10000GB, avail 08/15/05, HP Integrity Superdome cluster 86,282.7 QphH@10000GB, $161.24/QphH@10000GB, avail 04/06/05, HP Integrity Superdome 49,104.5 QphH@10000GB, $118.13/QphH@10000GB, avail 03/25/04. TPC-H, QphH, $/QphH tm of Transaction Processing Performance Council (TPC).
[3] Sun Fire E25K 105,430.9 QphH@3000GB, $54.87/QphH@3000GB, avail 01/27/06, IBM eServer p5 595 100,512.3 QphH@3000GB, $53.32/QphH@3000GB, avail 03/01/06, HP Integrity Superdome 71,847.8 QphH@3000GB, $55.79/QphH@3000GB, avail 01/18/06. TPC-H, QphH, $/QphH tm of Transaction Processing Performance Council (TPC).
[4] SPECjbb2005 Sun Fire E25K (72-way, 72 chips, 144 cores) 1,164,995 bops, 32,361 bops/JVM submitted for review, Fujitsu PRIMEPOWER 2500 (128 chips, 128 cores) 1,157,619 bops, 72,351 bops/JVM. SPEC, SPECjbb reg tm of Standard Performance Evaluation Corporation. Results as of 02/10/06 on www.spec.org. Prices based on publicly documented discounted list prices.
[5] Sun Fire E25K US-IV+ @1.8GHz (144 threads, 144 cores, 72 chips), 1,644 SPECint_rate2000; Sun Fire E25K US-IV+ @1.5GHz (144 threads, 144 cores, 72 chips), 1,456 SPECint_rate2000; IBM eServer p5 595 POWER5+ 2.3GHz (128 threads, 64 cores, 32 chips, SMT on), 1,513 SPECint_rate2000; Sun Fire E25K US-IV @1.2GHz (144 threads, 144 cores, 72 chips), 852 SPECint_rate2000. SPEC, SPECint reg tm of Standard Performance Evaluation Results from www.spec.org as of 8/11/06.
[6] LHS BSCS iX Wireless Billing E25K 1,125,179 invoices/hr, 72 1.5 GHz US-IV+, 578 GB, StoreEdge 3510FC, Solaris 10,; E25K 1,264,490 invoices/hr, 72 1.8 GHz US-IV+, 578 GB, StoreEdge 3510FC, Solaris 10; HP Integrity Superdome 1,000,000 invoices/hr. More info www.lhsgroup.com.
|
