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

ssrs 2008 options to run faster Expand / Collapse
Author
Message
Posted Saturday, September 14, 2013 3:38 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 9:33 AM
Points: 379, Visits: 451
In an SSRS 2008 rreport that I am working on, I am having a performance problem. The report is taking about 30 minutes to run which is too long. My problem is there is a full file scan.
To make the report run faster, I am thinking I could run queries based upon the selection values of 3 different paramters users can select from. If this is possible can you show me sql on how to accomplish this goal? Would I use the same dataset?

If not, can you show me how you would use multiple datasets?
If my idea does not work, what would you recommend? Can you show me the sql?
Post #1494848
Posted Sunday, September 15, 2013 12:33 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 1:01 AM
Points: 929, Visits: 5,908
Hard to say given the limited information. One thing would be to filter as much out of the dataset as early as possible (in the stored procedure, if possible). The other option is to run the report on a schedule (refresh every hour?) and then users can see that. depends how up to date you need the report to be.
Post #1494896
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse