Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

3 Answers 3

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

Reporting Services Scale-Out Deployment Best Practices:

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

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

Your Answer

 
discard

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.