1

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

1

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

0
1

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

Reporting Services Scale-Out Deployment Best Practices:

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

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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