Setting Cache Sizes

For block storage databases for which you have Database Manager permissions, you can set the size of Essbase memory caches (index cache, data file cache, and data cache).

Cache sizes significantly impact database and general server performance. Appropriate cache sizes are determined by many factors, including database size, block size, index size, and available memory on the Essbase Server.

Cache-size settings become effective after databases are restarted.

To specify the sizes of database index caches, data file caches, and data caches:

  1. From Enterprise View or a custom view, select a database.
  2. Right-click, and select Edit , and then Properties.
  3. In the Database Properties window, select the Caches tab.
  4. Expand the Cache sizes node.
  5. For each cache, enter a value, in kilobytes, for the size of the cache.
  6. Click Apply .