Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

what do you mean by custom groups?

1017


Define different types of attributes in microstrategy desktop?

1284


Explain the Roles in mstr?

1027


Compare dataset and fileset?

1090


Explain fact?

1025


What are prompted filters?

988


How would you configure wh authentication?

1014


Your application mode has crashed. How would you get the instance back?

998


Your application mode has crashed. How would you run your i-server?

1044


Explain attribute?

1037


Explain two-tier connection?

996


How can you make the sql query to be based on a specific table of your choice?

1101


What is level metrics in microstrategy?

1104


What specific features and functionality do I get with olap services?

1010


what is smart metrics in microstrategy?

1080