Applies to
SSAS
Description
This performance counter relates to the measurement of Analysis Services MDX calculations. Generally, for every request, Analysis Services makes a file a request to the operating system (OS); the OS then checks to see if the file is in the cache before retrieving it from hard disk. This performance counter monitors the total number of calculation data caches registered. The msmdsrv.ini file has “LimitSystemFileCacheSizeMB” property which controls how many Analysis Services files will be cached.
Resolved by
DBAs, Server administrators, BI developers
Suggested solutions
- For a list of all cached files, make use of RAMMap.exe tool by Windows Sysinternals
- Add more physical memory to the computer
- Consider changing the value of “LimitSystemFileCacheSizeMB” property according to your RAM requirements
Additional research
Performance tips for SSAS
Identifying Cell by Cell Computation Mode in MDX queries
Examining MDX Query performance using Block Computation
Performance Counters (SSAS)