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 Report Performance Expand / Collapse
Author
Message
Posted Wednesday, September 4, 2013 8:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 13, 2014 4:58 AM
Points: 4, Visits: 63
I occasionally develop multiple data sets from my data source in the process of developing reports in SSRS and then settle on the one best suited for my purposes. Does keeping these unused, not referenced, extra datasets impact the performance of the server in running such reports? If I want to keep the extra datasets for future reference, can I simply comment them out somehow?
Post #1491336
Posted Wednesday, September 4, 2013 1:16 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:28 AM
Points: 1,170, Visits: 1,208
jaytuke (9/4/2013)
I occasionally develop multiple data sets from my data source in the process of developing reports in SSRS and then settle on the one best suited for my purposes. Does keeping these unused, not referenced, extra datasets impact the performance of the server in running such reports? If I want to keep the extra datasets for future reference, can I simply comment them out somehow?

Yes, those unreferenced datasets still get executed every time the report is run and could negatively impact your performance.

I verified this by creating a report with three datasets -- only the first one was referenced in the report. Setting up SQL Profiler to watch the database while the report ran shows that all three queries for the three datasets (one used in report, two unused anywhere in report) were executed.

You could comment out all of the code in the unused datasets in the report, but I would prefer just storing my "working" SQL in a folder on the dev machine.

HTH,
Rob

Post #1491492
Posted Thursday, September 5, 2013 5:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 13, 2014 4:58 AM
Points: 4, Visits: 63
Thanks!
Post #1492001
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse