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 is metadata in microstrategy?
how can you direct the sql generated to use a specifc table?
What is a implicit attribute in microstrategy?
Define different types of attributes in microstrategy desktop?
Explain 4gt switch?
Explain fact degradation?
What do you mean by consolidations?
How are microstrategy reports performance tuned?
What do you mean by inmon?
How would you configure wh authentication? Explain.
What is fact degradation?
Name the various types of filters?
Explain two-tier connection?
What happens if the owner of an object does not exist in the destination project?
What is a joint child?