Essbase Analytics Link (EAL) - Performance of some operation of EAL could be improved by tuning of EAL Data Synchronization Server (DSS) parameters
Posted
by Ahmed Awan
on Oracle Blogs
See other posts from Oracle Blogs
or by Ahmed Awan
Published on Fri, 30 Nov 2012 21:51:55 +0000
Indexed on
2012/11/30
23:13 UTC
Read the original article
Hit count: 247
/2. EPM/Performance Tuning
Generally, performance of some operation of EAL (Essbase Analytics Link) could be improved by tuning of EAL Data Synchronization Server (DSS) parameters.
a. Expected that DSS machine will be 64-bit machine with 4-8 cores and 5-8 GB of RAM dedicated to DSS.
b. To change DSS configuration - open EAL Configuration Tool on DSS machine.
->Next:
and define:
"Job Units" as <Number of Cores dedicated to DSS> * 1.5
"Max Memory Size" (if this is 64-bit machine) - ~1G for each Job Unit. If DSS machine is 32-bit - max memory size is 2600 MB.
"Data Store Size" - depends on number of bridges and volume of HFM applications, but in most cases 50000 MB is enough. This volume should be available in defined "Data Store Dir" driver.
Continue with configuration and finish it. After that, DSS should be restarted to take new definitions.
© Oracle Blogs or respective owner