Oracle Hyperion Sun M5000 and Sun Storage 7410
By Brad on Oct 13, 2009
The Sun SPARC Enterprise M5000 server with SPARC64 VII processors (configured with 4 CPUs) and Sun Storage 7410 Unified Storage System has achieved exceptional performance for Oracle Hyperion Essbase 220.127.116.11 and Oracle 11g database for hundreds of GB of data, 15 dimensional db and millions of members running on free and open Solaris 10. Oracle Hyperion is a component of Oracle Fusion Middleware.
The Sun Storage 7410 Unified Storage System provides more than 20% improvement out of the box compared to a mid-size fiber channel disk array for default aggregation and user based aggregation.
The Sun SPARC Enterprise M5000 server with Sun Storage 7410 Unified Storage System and Oracle Hyperion Essbase 18.104.22.168 running on Solaris 10 OS provides < 1sec query response times for 20K users in a 15 dimension database.
The Sun Storage 7410 Unified Storage system and Oracle Hyperion Essbase provides the best combination for large Essbase database leveraging ZFS and taking advantage of high bandwidth for faster load and aggregation.
- Oracle Fusion Middleware provides a family of complete, integrated, hot plugable and best-of-breed products known for enabling enterprise customers to create and run agile and intelligent business applications. Oracle Hyperion's performance demonstrates why so many customers rely on Oracle Fusion Middleware as their foundation for innovation.
|Sun SE M5000||4 x 2.4GHz SPARC64 VII||Solaris||Sun Storage 7410||120 min||448 min||17.5 min|
|Sun SE M5000||4 x 2.4GHz SPARC64 VII||Solaris||Sun StorageTek 6140||128 min||526 min||24.7 min|
Results and Configuration Summary
1 x Sun SPARC Enterprise M5000 (2.4 GHz/32GB)
1 x Sun StorageTek 6140 (32 x 146GB)
1 x Sun Storage 7410 (24TB disk)
Solaris 10 5/09
Installer V 22.214.171.124
Oracle Hyperion Essbase Client v 126.96.36.199
Oracle Hyperion Essbase v 188.8.131.52
Oracle Hyperion Essbase Adminstration services 64-bit
Oracle Weblogic 9.2MP3 -- 64 bit
Oracle Fusion Middleware
Sun's JDK 1.5 Update 19 -- 64-bit
Oracle RDBMS 184.108.40.206 64-bit
HP's Mercury Interactive QuickTest Professional 9.0
Oracle Hyperion is a OLAP based analytics application used to analyze business needs and plans that is highly dimensional detailed, such as "what-if" analysis to look into the future, build multi-user scenario modeling, planning, customer buying patterns, etc.The objective of the benchmark is to collect data for the following Oracle Hyperion Essbase benchmark key performance indicators (KPI):
Database build time: Time elapsed to build a database including outline and data load.
Database Aggregation build time: Time elapsed to build aggregation.
Analytic Query Time: With user load increasing from 500, 1000, 2000, 10000, 20000 users track the time required to process each query and hence track average analytic query time.
Analytic Queries per minute: Number of queries handled by the Essbase server per minute Track resource, i.e. CPU, memory usage.
The benchmark is based on the data set used by Product Assurance for 2005 Essbase 7.x testing.
40 flat files of 1.2 GB each , 49.4 GB in total
10 million rows per file, 400 million rows total
28 columns of data per row
49.4 GB total size of 40 files
Database outline has 15 dimensions (five of them are attribute dimensions)
Customer dimension has 13.3 million members
Key Points and Best Practices
The Sun Storage 7410 was configured with iSCSI.
Oracle Hyperion Enterprise, www.oracle.com/solutions/mid/oracle-hyperion-enterprise.html, results 10/13/2009.