|
Hi 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
(comments are locked)
|
|
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. Hi Thanks for your answere and sorry for my late reply, firstly i didnt understand what you meant by poor cached query/outdated stats. (Try updating the statistics) what does it mean?
Dec 02 '09 at 08:04 AM
Usha
(comments are locked)
|
|
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). I am using stored procedures and when i run the procedure then there is no problem. The actual problem is only showing the report
Dec 02 '09 at 08:08 AM
Usha
(comments are locked)
|
