Microsoft SQL Server 2005 Analysis Services

its current balance and the price of memory, the file store makes a decision to clean a part

of the memory it holds. Therefore, the file store swaps the least used pages to a disk, and

the most used pages remain in memory. This way, the memory used by file stores depends

on the state of the memory usage in the whole system. If the server is busy with work

that hits the caches and does not retrieve data from dimensions, after some period of

time, all the file stores might be swapped to disk and the cache will accumulate a large

amount of data. If usage of the caches decreases, the caches will be cleaned and more

pages of the file stores will be loaded ...