AnsweredAssumed Answered

Analysis Service performance issue

Question asked by amitvankudre on Aug 21, 2018
Latest reply on Aug 22, 2018 by VasanthakumarR

Hi All,

 

I have around 2800 AF Analysis calcs running at 1 min freq. However, the Analysis service was not able to handle those and I tried using an offset, post which many of them started updating. I have currently divided into 6 groups, each with a frequency of 1 min and offsets of 3,6,9,etc...In spite of this, 5 of the 6 groups update correctly while 1 group always shows a lag, which increase with time.

 

I believe that 2800 is not too big a number for Analysis service not to be able to handle those with 4 CPU cores and 16GB GB RAM.Is there a parameter I can change to resolve this evaluation lag ? Particularly, what is the EvaluationPartitionSize parameter and what does its default value of 10000 signify ? Can this be changed to ensure faster evaluation of all calcs ?

Or is there any other method to resolve a calculation lag ?

 

The current config is as below :

 

 

Thanks and Regards,

Amit Vankudre

Outcomes