Reporting Services slow

  • 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?

  • 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.

    ----------------------------------------------------

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply