We have a web application developed and populating reports using SSRS from UI. We are deploying reports in a different server. Problem is most of the time, the reports population will be very slow (7 times in 10 times the report generation is very slow). What could be the problem?
If I restart the server then again it will generate fastly. What could be the problem? (Using SQL Server 2005)
Thanks in advance Usha
My first guesses would be a poor cached query plan or outdated stats.
Try updating the statistics on the underlying tables and see if that helps.
answered Nov 26 '09 at 10:09 AM
In addition to what Blackhak-17 has said. It would be helpful to know how you are querying the database, are you using stored procedures or adhoc SQL in the reports themselves? If you are using stored procedures this behavior sounds like "parameter sniffing" (google/bing that).
answered Dec 01 '09 at 11:14 AM