Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?



share|improve this question
up vote 1 down vote accepted

SSRS is pretty slow when it comes to generating reports. The T/SQL tuning is about the best you can do.

share|improve this answer
thanks...this is what I first thought – Manjot Jul 12 '10 at 23:48

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.

share|improve this answer
also check out this linke on rendering performance – Jason Horner Jul 9 '10 at 13:14
thank you very much – Manjot Jul 12 '10 at 23:48

Reporting Services Scale-Out Deployment Best Practices:

share|improve this answer
thank you very much – Manjot Jul 12 '10 at 23:46

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.