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 / 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 |
What is level prompt?
Does microstrategy intelligence server support scheduling?
What is scanmd and md doctor?
What information is shared by the application across microstrategy web nodes?
can metadata be manually edited? If yes, how?
What do you mean by trimming sql in microstrategy?
What do you mean by consolidations?
What is percent-to-total shortcut metric in microstrategy?
Can you create an event based schedule in microstrategy? How?
How can i optimize a report in microstrategy environment?
What is transformation metric in microstrategy?
Explain attribute?