MicroStrategy ONE

Edit Server-Level Governing Settings

MicroStrategy ONE (September 2024) adds the Unload cube caches not used for (minutes) setting.

Starting in MicroStrategy ONE (June 2024), the minimum value for the Maximum memory for working set cache (MB) setting is 15% of the total memory.

The same governing settings for Intelligence Server that are available in MicroStrategy Developer are available in Workstation.

The ability to view or edit certain settings is determined by a user's privileges. All necessary privileges are included in the Administrator role by default. You must belong to the System Administrators group to use this feature.

  1. Open the Workstation window.
  2. In the Navigation pane, click Environments.
  3. Right-click a connected environment and choose Properties.

    4. Choose Get Info if you are using a Mac.

  4. In the left pane, click Governing settings.

Fields

Jobs

Maximum number of jobs Limits the number of concurrent jobs that may exist on this Intelligence server. Concurrent jobs include report, element, and auto-prompt requests that are executing or waiting to execute. Finished (open) jobs, cached jobs, or jobs that returned errors are not counted. A value of -1 indicates no limit. The default is 10000.

Sessions

Maximum number of user sessions Limits the number of user sessions (connections) for an Intelligence server. A single user account may establish multiple sessions to an Intelligence server. Each session connects once to the Intelligence server and once for each project the user accesses. Project sessions are governed separately with a project level setting. When the maximum number of user sessions is reached, users cannot log in, except for the administrator, who may wish to disconnect current users or increase the governing setting. A value of -1 indicates no limit. This value is set to 320 by default.

Clients session idle time (sec) Controls session idle time for Web, Library, Workstation, Command Manager, and Integrity Manager. The maximum value is 999,999. The minimum value is 0. You can also select No Limit. The default value is 600.

Tools session idle time (sec) Controls session idle time for Developer and Object Manager. The maximum value is 999,999. The minimum value is 0. You can also select No Limit. The default value is 1800.

Advanced Fields

Click Advanced to view these additional fields.

Memory Settings

Minimum reserved memory for external processes (%) Specify the amount of memory (as a percentage of the total system memory) that Intelligence server cannot use. This may be useful if the machine is also used to run software from other parties and is not solely dedicated to Intelligence server. This value is set to 0 by default.

If the machine has Intelligence server and another application running on it, and you want less than half of the total memory to be available to Intelligence server, you could specify a reserved memory of 60 percent. This leaves 40 percent for Intelligence server.

Intelligence server always reserves a minimum of 500 MB for its own operation. If the machine does not have this much memory, or if the Minimum reserved memory would leave less than 500 MB available for Intelligence server, no memory is reserved for other processes.

Memory request idle time (sec) The amount of time Intelligence server denies requests while operating in memory request idle mode. This value is set to 600 by default.

If Intelligence server determines that a new request would cause the available virtual memory to drop below acceptable levels, the request is denied, and Intelligence server goes into memory request idle mode. After denying the request, Intelligence server remains in memory request idle mode until a request is made that would not result in a possible memory depletion situation. If no such request is made before the Memory request idle time expires, Intelligence server stops and restarts.

Maximum single allocation size (MB) If the request exceeds this limit, the request is denied. Each request is treated in the order it is received, so each is subject to the original memory limit. This prevents a few large jobs or reports from consuming large portions of memory at the expense of smaller jobs. To disable single allocation governing, select Disabled from the drop-down.

Memory Release

Unload cube caches not used for (minutes) Starting in MicroStrategy ONE (September 2024), the cube cache can be released from memory if not accessed by the specified amount of time. You can use this setting to proactively unload unused cube caches from memory to keep Intelligence Server memory usage in check. The value is set to No Limit by default. To activate this setting, set it to a value based on your business needs. You can specify a value between 1 minute and 525600 minutes (equivalent to one year).

Jobs and User Connections

For job and history list governing, exclude reports embedded in Report Services Documents If this option is enabled, reports executed as part of a Report Services Document are not counted against the server-level job limits above and the project-level job limits set in the All Settings section of the project's Properties dialog. This option is disabled by default.

Enable background execution of documents after their caches are hit If this option is enabled, when a document cache is hit, Intelligence server displays the cached document and re-executes the document in the background. If this option is disabled, when a document cache is hit, Intelligence server displays the cached document and does not re-execute the document until a manipulation is performed. This option is disabled by default.

Selecting this option speeds up document manipulation, but may increase the load on Intelligence server if users frequently load documents without manipulating them.

Cache and Log Settings

Maximum memory consumption for XML (MB) Limits the memory consumption for XML files. Set the limit according to the size expected of the XML documents to be generated to avoid memory-related errors. The default value is 512 MB. The maximum value is 1024 MB.

Maximum memory for working set cache (MB) Specifies the size of the pool of memory (in megabytes) allocated for creating and initially storing reports in the working set. This is also the size of the largest working set that can be created. The default is 2048 MB (2GB). The minimum value is 200 MB. The maximum value is 4194303 MB (4TB). Starting in MicroStrategy ONE (June 2024), the minimum value for this setting is 15% of the total memory.

If you set this limit to more memory than the operating system can make available, Intelligence server allocates approximately 10% of the available server memory and then fine-tunes the allocation based on performance monitor log data recorded over time.

Working Set file directory Specifies the location where the user's active working sets are written to disk if they have been forced out of the pool of memory allocated for the Maximum RAM for working set cache.

The default is .\TmpPool.

Session Recovery

Session recovery and deferred inbox storage directory Specifies where the session information is written to disk. The default is .\TmpPool.

Enable web user session recovery on Logout Select this option to allow users to recover the report, document, or dashboard they were in when their session ended.