SSRS report - rendering takes a long time

Question

I have a report that can have a large number of pages - hundreds. What's happens is that the rendering takes a long time - 10 to 30 min. Often it just crashes. Are there some design strategies to improve rendering time?

Thanks

Answer 1

Hi @mark goldin ，
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.
  Best Regards,
  Joy

  ---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

A performance killer is the usage of build-in field "TotalPages". SSRS / ReportViewer have to first render all pages to get the page count and that take time; are you using this field in your reports?