Bests Mark Set by SPARC Enterprise M5000 Server August 31, 2012,
Volume 174, Issue 5
Oracle's SPARC T4-2 Server (2 cpus), configured with a Sun Storage F5100 Flash Array and running Oracle Solaris 10 with Oracle Database 11g and Oracle Essbase 126.96.36.199.100, outperformed the previous published results on Oracle's SPARC Enterprise M5000 server (4 cpus) with Oracle Essbase 188.8.131.52 on Oracle Solaris 10 by 80%, 32% and 2x performance improvement on Data Loading, Default Aggregation and Usage Based Aggregation, respectively. The SPARC T4-2 server achieved sub-second query response times for 20,000 users in a 15 dimension database and was able to aggregate and store values in the database for a 15 dimension cube in 398 minutes with 16 threads and in 484 minutes with 8 threads. The Sun Storage F5100 Flash Array provides more than a 20% improvement out-of-the-box compared to a mid-size fiber channel disk array for default aggregation and user-based aggregation.