Performance issues with SSAS

Hello, Jesica!

Thank you for writing to us.

There are several general recommendations to achieve better performance when working with Flexmonster Accelerator:

1. Please make sure that Flexmonster Accelerator and the MS Analysis Services instance are located on the same machine. This will minimize the time spent on data transfer between the Accelerator and the cube.
2. Increasing the cache size limit could help improve the performance of repeating queries. The cache is configured with the CACHE_ENABLED property to enable it and CACHE_MEMORY_LIMIT to set maximum cache size in MB. Also, you can remove the memory limit by setting the CACHE_MEMORY_LIMIT to 0.

Please let us know if our recommendations helped you.

Kind Regards,
Maksym

Hello, Jesica!

Thank you for your reply.
We are glad to hear that you could solve the performance issue with the update.
Feel free to contact us if more questions arise.

Best Regards,
Maksym