A report is taking few seconds to run.The same report is taking very long time on the next day without doing any kind of changes in the report. What could be the reason? how do you tune the report.
Answer Posted / balav
First make sure you,
1. Check for the Backend loads being run on the time of report execution.That might also impact the report execution time.
2. But in future to avoid this long run, you can check the SQL global optimization setting of VLDB properties.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
what do you mean by custom groups?
Define different types of attributes in microstrategy desktop?
Explain the Roles in mstr?
Compare dataset and fileset?
Explain fact?
What are prompted filters?
How would you configure wh authentication?
Your application mode has crashed. How would you get the instance back?
Your application mode has crashed. How would you run your i-server?
Explain attribute?
Explain two-tier connection?
How can you make the sql query to be based on a specific table of your choice?
What is level metrics in microstrategy?
What specific features and functionality do I get with olap services?
what is smart metrics in microstrategy?