Performance, Snapshots, Caching (Reporting Services)
Applies To: SQL Server 2016
Report server performance is affected by a combination of factors that include hardware, number of concurrent users accessing reports, the amount of data in a report, and output format. To understand the performance factors that are specific to your installation and which remedies will produce the results you want, you will need to get baseline data and run tests. For more information about tools and guidelines, see the following publications on MSDN: Reporting Services Performance Optimization and Using Visual Studio 2005 to Perform Load Testing on a SQL Server 2005 Reporting Services Report Server.
General principles to consider include the following:
Report processing and rendering are memory intensive operations. When possible, choose a computer that has a lot of memory.
Hosting the report server and the report server database on separate computers tends to provide better performance than hosting both on a single high-end computer.
If all reports are processing slowly, consider a scale-out deployment where multiple report server instances support a single report server database. For best results, use load balancing software to distribute requests evenly across the deployment.
If a single report is processing slowly, tune report dataset queries if the report must run on demand. You might also consider using shared datasets that you can cache, caching the report, or running the report as a snapshot.
If all reports process slowly in a specific format (for example, while rendering to PDF), consider file share delivery, adding more memory, or choosing a different format.
To find out how long it takes to process a report and other usage metrics, review the report server execution log. For more information, see Report Server ExecutionLog and the ExecutionLog3 View.
For more information about how to mitigate performance issues by tuning memory management configuration settings, see Configure Available Memory for Report Server Applications.
Monitoring Report Server Performance
Describes the performance objects you can use to track the processing load on your server.
Set Report Processing Properties
Describes ways of configuring a report to run on demand, from cache, or on a schedule as a report snapshot.
Configure Available Memory for Report Server Applications
Describes how you can override default memory management behavior.
Caching Reports (SSRS)
Describes report caching behavior on a report server.
Cache Shared Datasets (SSRS)
Describes shared dataset caching behavior on a report server.
Process Large Reports
Provides recommendations on how to configure and distribute a large report.
Setting Time-out Values for Report and Shared Dataset Processing (SSRS)
Explains how to set time outs on query and report processing.