When memory or performance issues occur in Strategy Intelligence Server 2021, it is recommended to collect performance related logs. The following counters listed below should be collected when troubleshooting issues on a UNIX/Linux environment.
The names of the counters may differ slightly depending on the UNIX operating system used.
Enable ALL counters from the following 6 Categories
1 - Memory (all counters within this Category)
2 - Strategy Server Jobs (all counters within this Category)
3 -Strategy Server Users (all counters within this Category)
4 -Process (The following specific counters)
"% CPU time" here is processor time spent in the Intelligence Server only. Comparing this value to the overall system processor use reveals whether it is the Intelligence Server or some other process occupying processor time. (Other processes may include Strategy database connection processes. This is an important data point for troubleshooting, as the diagnosis of the problem will be different depending on the component showing high CPU use.)
RSS stands for "resident set size" and indicates the amount of physical RAM occupied by the Intelligence Server process. Size is the total size of the Intelligence Server process, including virtual memory use (pages swapped out to disk).
5 - Processor (The following specific counters)
Processor time is broken down into four values: Idle Time, System Time (for operating system activities), User Time (for user processes, including Strategy Intelligence Server 9.4.x - 10.x), and Wait Time, during which the processor is waiting for memory to be paged in from disk. High wait time indicates virtual memory contention, which can cause poor performance.
6 - System (The following specific counters)
While the memory and processor performance objects drill into more detail, these overall system totals are useful for comparison against the detailed measurements.
In some cases, you may need to restart the Intelligence Server for the updated configuration to be applied.
Additional Content
For Intelligence Server on Windows, the following Knowledge Base article should be consulted for performance counters:
KB19154: Recommended performance logging counters to enable when troubleshooting memory or performance issues in MicroStrategy Intelligence Server 9.x in Microsoft Windows environments
Users can consult the following Strategy knowledge base article for details on capturing these counters into logs to be provided to Strategy Technical Support.
KB13313: How to enable logging of performance counters using the Diagnostics and Performance Logging tool for MicroStrategy Intelligence Server 9.x in Microsoft Windows and Unix
For environments that do not have a GUI, a command line version of the Strategy Diagnostics Configuration tool can facilitate the collection of Performance Counters, as per the following Knowledge Base article:
KB46316: How to enable recommended performance counter logging for MicroStrategy server instances from the command line using MSTRCTL command in MicroStrategy Intelligence Server Universal 9.x - 10.x
