How to Speed up MS SQL Reporting Services on First Run

Reporting & BI Tips & Hidden Features SQL & Data

Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.

MSSQLTips has a great new article up on How to Speed up MS SQL Reporting Services on First Run. If you use Reporting Services with Dynamics GP you’ve likely seen this issue where the first connection to print a report is very slow and then the site is responsive after that. The good folks at MSSQL Tips look at how to fix this.

Original article: https://www.mssqltips.com/sqlservertip/2197/how-to-speed-up-ms-sql-server-reporting-services-ssrs-on-first-run/