Best Practices for Tuning your System

MicroStrategy recommends the following best practices for designing, configuring, and tuning your MicroStrategy system. For detailed information about increasing system performance by tuning the governing settings, see the remainder of this section.

• When designing your projects and data warehouse, follow the MicroStrategy best practices as outlined in Prerequisites.
• When configuring your network, follow the MicroStrategy best practices as outlined in How the Network can Affect Performance.
• Use Intelligence Server's Memory Contract Manager to manage memory usage, as described in Governing Intelligence Server Memory Use with Memory Contract Manager.
• Use MicroStrategy system privileges to restrict users' access to certain features, as described in Governing User Profiles.
• Assign a high priority to more time-sensitive jobs, and a low priority to jobs that may use a great deal of system resources, as described in Prioritize Jobs.
• Enable Intelligence Server thread balancing, as described in Results Processing.
• Ensure that report and document designers are aware of the features that can place an exceptionally heavy load on the system. These features are listed in detail in Design Reports.
• Enable automatic memory tuning and dynamic buffer sizing.