Caches in a Clustered Environment

Did my Report Hit a Cache?

If the cache is available on the local node, the Cache Monitor increments the hit count. If the cache is retrieved from another node, speed of response can indicate whether a cache is hit. Statistics tables can provide additional data on cache hits.

What Cache Did My Report hit?

The statistics logs show cache hit statistics, logged to the STG_IS_CACHE_HIT_STATS table. This information is later loaded in the IS_CACHE_HIT_STATS table as part of the Enterprise Manager data load process.

How Do I Automate the Deletion of Caches on Multiple Nodes?

Use MicroStrategy Command Manager to run scripts that automatically delete caches. See Automating Administrative Tasks with Command Manager.