Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

RDL Reports Expand / Collapse
Author
Message
Posted Monday, December 24, 2012 3:37 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 6:37 AM
Points: 1,938, Visits: 2,374
Hi,

I have a dashboard which contains many RDL reports but it takes about 30 minutes. How can improve the performance so that it get load in less time?



_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1399857
Posted Monday, December 24, 2012 8:01 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, November 21, 2014 12:17 PM
Points: 1,217, Visits: 1,262
kapil_kk (12/24/2012)
Hi,
I have a dashboard which contains many RDL reports but it takes about 30 minutes. How can improve the performance so that it get load in less time?

No real secret here, you need to look at the T-SQL or MDX (if report is from an SSAS cube) behind each of those reports to see what is taking so long. Run each report individually -- perhaps it is just one report that's taking so long to run.

Good luck,
Rob
Post #1399909
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse