Strategy recommends the following best practices for designing, configuring, and tuning your Strategy 11 Intelligence Server
When designing your projects and data warehouse, follow below Prerequisites:
You are familiar with Strategy Developer and Strategy Intelligence Server.
You are familiar with Strategy HTML documents and Report Services documents.
You have a Report Services product license if you are using Report Services documents. HTML documents do not require a Report Services product license.
You have installed Strategy Developer on a Windows machine.
You have installed Strategy Intelligence Server on a Linux machine.
When configuring your network, follow below best practices:
Place the Web server machines close to the Intelligence Server machines.
Place Intelligence Server close to the both the data warehouse and the metadata repository.
Dedicate a machine for the metadata repository.
If you use Enterprise Manager, dedicate a machine for the Enterprise Manager database (statistics tables and data warehouse).
If you have a clustered environment with a shared cache file server, place the shared cache file server close to the Intelligence Server machines.
Use Intelligence Server's Memory Contract Manager to manage memory usage
Refer to Technical Document below for the MCM usage:
KB7295: What is the Memory Contract Manager in MicroStrategy Intelligence Server 10.x and later? PART 1
KB7295: What is the Memory Contract Manager in MicroStrategy Intelligence Server 9.x and later? PART 2
Use Strategy system privileges to restrict users' access to certain features
The user profile can be defined as what the user can do when logged in to the system. If you allow users to use certain features in the system, they can affect the system's performance. For example, when users schedule report executions, this creates user sessions on Intelligence Server, thus placing a load on it even when the users are not actively logged in.
You can limit these types of activities by restricting various privileges:
Subscription-Related Privileges
History List Privileges
Report Manipulation Privileges
Exporting Privileges
OLAP Services Privileges
Assign a high priority to more time-sensitive jobs, and a low priority to jobs that may use a great deal of system resources
Refer to Technical Document below for more details:
KB8486: What is Job Prioritization and Connection Management in MicroStrategy Intelligence Server 9.x and 10.x?
Ensure that report and document designers are aware of following features that can place an exceptionally heavy load on the system:
Complex analytic calculations (Analytic Complexity)
Subtotals (Subtotals)
Page-by (Page-By Feature)
Prompt complexity (Prompt Complexity)
Report Services documents (Report Services Documents)
Intelligent Cubes (Intelligent Cubes)
Enable automatic memory tuning and dynamic buffer sizing:
Refer to Technical Document below for automatic memory tuning feature:
KB441579: New behavior of enabling “MSTR_MEM_CACHE_AUTO_CONFIG” in MicroStrategy Secure Enterprise 11.0 and above
Refer to Technical Document below for dynamic buffer sizing feature:
New Buffer Size Dynamic Growth Algorithm in MicroStrategy Secure Enterprise 11.0 and above
