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 11.1.2.2.100, outperformed the previous published results on Oracle's SPARC Enterprise M5000 server (4 cpus) with Oracle Essbase 11.1.1.3 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.

More Information

Improved Throughput and Response Time of SPARC T4-2

Read More ... [...read more...]

		fullsource
Print Email Current Profile Archive Blog Generate newsletter