You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Low Index Cache Setting and high Index cache Hitting ratio

edited Aug 2, 2018 2:36AM in Essbase 6 comments

Summary

Low Index Cache Setting and high Index cache Hitting ratio

Content

One of Essbase databases is configured to use Buffered I/0 and as of now size of .ind file is  2312 MB. Please is the snapshot of storage section:

Below are the values for Index cache setting:

Even after such low index cache setting hit ratio of index cache is very high .93

These are the stats from last one month and lot's of data retrieval was done. I was expecting the hit ratio to be low as cache size is much lesser than .ind file. 

We are using Essbase 11.1.2.4.012.7 and smartview version is 11.1.2.5.610.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!