How to make SSRS 2005 run fast in general?

Question

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

score 1 · Accepted Answer · answered Jul 08 '10 at 06:50

1

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

answered Jul 08 '10 at 06:50

mrdenny

27,174
4
41
69

score 1 · Answer 2 · answered Jul 09 '10 at 13:10

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.

answered Jul 09 '10 at 13:10

Jason Horner

612
2
6
13

1

also check out this linke on rendering performance http://msdn.microsoft.com/en-us/library/dd353300(SQL.90).aspx#Render – Jason Horner Jul 09 '10 at 13:14

score 0 · Answer 3 · answered Jul 09 '10 at 13:51

0

Reporting Services Scale-Out Deployment Best Practices:

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

answered Jul 09 '10 at 13:51

Guy

2,668
2
20
24

How to make SSRS 2005 run fast in general?

3 Answers3