MicroStrategy ONE

Limiting the Amount of Memory Available for Element Caches

You can control the amount of memory that element caches use on both Intelligence Server (set at the project level) and the Developer machines. This memory is referred to as the cache pool. If Intelligence Server attempts to cache a new element request, but there is not enough available cache pool space to store all of the new elements, existing elements must be removed from memory before the new ones can be cached. When this happens, the least recently used 25% of element caches are removed from the cache.

You can configure the memory setting for both the project and the client machine in the Cache: Element subcategory in the Project Configuration Editor. You should consider these factors before configuring it:

  • The number of attributes that users browse elements on, for example, in element prompts, hierarchy prompts, and so on
  • The number of unique elements

    For example, attribute "Year" (10 years = 10 elements), attribute "city" (500 cities = 500 elements)

  • Time and cost associated with running element requests on the data warehouse

    For example, if the element request for cities runs quickly (say in 2 seconds), it may not have to exist in the element cache.

  • The amount of RAM on the Intelligence Server machine

To Set the RAM Available for Element Caches for a Project

  1. In Developer, log into a project. You must log in with a user account that has administrative privileges.
  2. From the Administration menu, point to Projects, and then select Project Configuration.
  3. Expand Caching, expand Auxiliary Caches, then click Elements.
  4. Specify the amount of RAM (in megabytes) in the Server: Maximum RAM usage (MBytes) box.
    • The default value is 1 megabyte.
    • If you set the value to 0, element caching is disabled.
    • If you set it to -1, Intelligence Server uses the default value of 1 MB.
  5. Specify the amount of RAM (in megabytes) in the Maximum RAM usage (MBytes) box.

    The new settings take affect only after Intelligence Server is restarted.

To Set the RAM Available for Element Caches on Developer

  1. In the Project Source Manager, click the Caching tab and within the Element Cache group of controls, select the Use custom value option.

    If you select the Use project default option, the amount of RAM will be the same as specified in the Client section in the Project Configuration Editor described above.

  2. Specify the RAM (in megabytes) in the Client section in the Maximum RAM usage (MBytes) field.