Are there any general rules/tips which we can use to run Sql Server Reporting Services 2005 reports faster?
I have been tuning the Tsql behind the reports but does there exist any SSRS specific performance tuning?
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
upgrade to SSRS 2008 or 2008 R2. The rendering engine and the startup times are much faster.
That being said, if part of the issue is with start times, I have heard of people creating warmer scripts to ensure the app pool is constantly running. Caching and saving report execution may ba an option for you as well. Especially in a batch load DW environment or if the users can stand near current results.
Reporting Services Scale-Out Deployment Best Practices: