Home / server / Questions / 158402
Accepted
Manjot
Asked: 2010-07-08 15:21:08 +0800 CST

How to make SSRS 2005 run fast in general?

  • 772

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?

regards

Manjot

ssrs performance-tuning

3 Answers

  1. Best Answer

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

    • 1

  2. 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.

    • 1
    • 0