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

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

Related posts about /2. EPM/Performance Tuning