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.
DBAs, Server administrators, BI developers
- 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