SSAS Clearing the Cache
User Rating: / 0
PoorBest 
Written by Chris Schmidt   
Monday, 17 June 2013 21:56

In SSAS, when you're trying to do performance tests, it's important to know what performance is from the cold cache. You definitely don't want a warm cache messing with your measures that you're trying to get metrics on! An important item of consideration is that SSAS is NOT like the database engine side of SQL Server, in that you run one command and you're done. Since SSAS has 3 separate distinct parts (the formula engine, the storage engine, and the file system) you want to ensure that you clear the cache in all 3 places in order to get a clean run.

Read more...

 

 

XL Cubed