Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

ssrs 2008 options to run faster Expand / Collapse
Posted Saturday, September 14, 2013 3:38 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 3:23 PM
Points: 568, Visits: 704
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


Group: General Forum Members
Last Login: Yesterday @ 7:06 AM
Points: 2,135, Visits: 12,280
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