I'm trying to increase the performance of my OLAP Cube and i thought placing the CUbe entirely in RAM can solve this problem. can anyone please answer me , if this can be done using Traditional BI i.e SSAS and how?

• Edited by Nagarjuna Kendyala 3 hours 10 minutes ago

Hi Nagarjuna:

I do not believe you can load the entire cube into RAM and even if you were able to do so, I don't think you'll be able to solve you performance issues.

Here is a thread with the same discussion and it has some good links that you can visit to learn more about where the performance issues are emanating from  - How to cache all SSAS 2008 cube processed data into RAM

Also, please tale a look at the followoing guide - Analysis Services Performance Guide

Hope this helps.

Hello,

A tabular mode cube is located in memory.

There is no direct way to force a "classic" multidimension cube to be loaded completly, but after processing of the cube you can warm up the cache, see

http://blogs.msdn.com/b/sqlcat/archive/2007/04/26/how-to-warm-up-the-analysis-services-data-cache-using-create-cache-statement.aspx

http://sqlbits.com/Sessions/Event5/cache-warming_strategies_for_analysis_services_2008