Hello All,
Approximately 140 reports soon going to live in our production Server. Almost 90% of reports will be Scheduling. I want to know how to estimate how much data will be pull by reports. What are the Scenarios i need to take into consideration before making estimation.
I have few reports which are running on Production Server can i use the these reports and estimate the size of the reports will be in prodcution or not.
Thanks a lot!
sid786 (BOB member since 2008-10-06)
Hi
Its really difficult to answer your question to be honest. There should be a lot things needs to consider and basically you needs to know what’s your database size and how much data each report going to retrieve and how the selection criteria etc. etc. The better way to understand the scenario is to consult your DBA. They should be answering your question
Regards
Siva.M
looksmee 
(BOB member since 2006-02-08)
Do you have the reports currently in your development environment? If so, then investigate the reports there. Look at the report file size in the output FRS and do a pick of the most common reports and run the query and see how many rows/data it returns.
Looking at the reports you currently got in your prod system can also be a good measure, depending on how similar they are to your new reports…
J0sh 
(BOB member since 2006-10-09)