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
Author
Message
Posted Monday, July 15, 2013 2:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 20, 2014 10:26 AM
Points: 24, Visits: 109
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


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 10, 2014 6:20 PM
Points: 220, Visits: 695
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