Version 2021

Maximum Parallel Queries Per Report

Maximum Parallel Queries Per Report is an advanced property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.

The Maximum Parallel Queries Per Report property determines how many queries can be executed in parallel as part of parallel query execution support. By default, a maximum of two queries can be executed in parallel, and you can increase this number to perform additional queries in parallel. For data that is integrated into MicroStrategy using Data Import, the default maximum number of queries that can be executed in parallel is five. When determining this maximum, consider the following:

  • You must enable parallel Query execution to perform multiple queries in parallel. To enable parallel Query execution, see Maximum Parallel Queries Per Report.
  • The number of queries executed in parallel is also dependent on the report or Intelligent Cube that is being executed. For example, if the maximum is set to three but a report only uses two passes of SQL, then only those two queries can be performed in parallel.
  • When multiple queries are executed in parallel, this means that the actual processing of the multiple queries is performed in parallel on the database. If a database is required to do too many tasks at the same time this can cause the response time of the database to slow down, and thus degrade the overall performance. You should take into account the databases used to retrieve data and their available resources when deciding how to restrict parallel Query execution.

Levels at Which You Can Set This

Project only