Enhance SSRS 2008 R2 report performance

Question

Hi, We are using SQL Server 2008 R2. I am looking at different options that would enhance performance of the report when run in BIDS environment or ReportServer. I usually call a stored procedure andmost of the time these stored procedures take less than 10 secs to retrieve results in SSMS but take over 5 mins from the ReportServer. What areas should we look at?

SQL Server Version: Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64)  Enterprise Edition (64-bit) (Service Pack 1) (Hypervisor)

Thanks in advance..............

Answer 1

Hi Ione721,

I will recommend two thing to read to overcome on your problem because it will resolve through hit and trial:

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/6ef426ee-2111-49db-8d88-ba2b809ef2e1/

http://sqlcat.com/sqlcat/b/technicalnotes/archive/2009/01/14/reporting-services-performance-optimizations.aspx

i hope this helps you.

Thanks,

Zaim Raza.