up vote 1 down vote favorite
1
share [g+] share [fb]

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

link|improve this question
82% accept rate
feedback

3 Answers

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.

link|improve this answer
thanks...this is what I first thought – Manjot Jul 12 '10 at 23:48
feedback
up vote 1 down vote

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.

link|improve this answer
1  
also check out this linke on rendering performance msdn.microsoft.com/en-us/library/dd353300(SQL.90).aspx#Render – Jason Horner Jul 9 '10 at 13:14
thank you very much – Manjot Jul 12 '10 at 23:48
feedback
up vote 0 down vote

Reporting Services Scale-Out Deployment Best Practices:

http://sqlcat.com/technicalnotes/archive/2008/10/21/reporting-services-scale-out-deployment-best-practices.aspx

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

Your Answer

 
or
required, but never shown
discard

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