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,