EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB16390: Why does the Job Monitor show more executing jobs of low priority than maximum possible configured under prioritization in MicroStrategy Intelligence Server?


Community Admin

• Strategy


Reports are first resolved by the Resolution Engine before being executed by the Query Engine against the warehouse.

The maximum number of jobs for each priority, high, medium, and low, can be configured at Database Instance > Job Prioritization, as shown below:
 

ka04W00000148WpQAI_0EM440000002BTW.jpeg

 
For more information about how to take advantage of this setting, refer to the following Strategy Knowledge Base technical notes:
 

  • KB8486: What is Job Prioritization and Connection Management in MicroStrategy Intelligence Server 9.x and 10.x?
  • KB4696: How to configure Report Cost in MicroStrategy Developer 9.4.x -10.x

In this example, notice that the number of connections by priority is set to 2 for all of the priorities. However, when there are multiple jobs concurrently running, the Job Monitor may look like below:
 

ka04W00000148WpQAI_0EM440000002BTb.jpeg

 
In Strategy Intelligence Server, reports are first resolved by the Resolution Engine before being executed by the Query Engine against the warehouse. While waiting or being resolved, jobs may appear in the Job Monitor under the status of 'Waiting' or 'Executing' and with priorities as low. For this example, 5 jobs have status of "Executing," while it is not all of these executing jobs that represent the query execution.
 


Comment

0 comments

Details

Knowledge Article

Published:

May 16, 2017

Last Updated:

May 16, 2017