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

Reporting Services slow Expand / Collapse
Posted Monday, July 15, 2013 2:54 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 31, 2014 4:32 AM
Points: 40, Visits: 154
My Reporting Services is getting slow to jump from report to report. Is there any way to improve your performance? It will be something I can change on my server?
Post #1473529
Posted Wednesday, July 31, 2013 10:08 AM



Group: General Forum Members
Last Login: 2 days ago @ 3:07 PM
Points: 499, Visits: 1,110
Are the datasets in the reports using stored procedures or is the sql typed in directly? The former will be faster. If they are procedures... are they also slow when executing from SSMS? If so optimise the queries, start with indexing. If not is the reporting service on a virtual server? Do you have the reporting database set to simple recovery mode?

These are a few things to start out with.
Post #1479571
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse