sql server reporting services: Improve inital load time of Report Manager webstie -- sql server reporting services

Improve inital load time of Report Manager webstie

JasonDWilson
8/28/2007 12:24:05 PM

sql server reporting services: Is there a way to improve the inital load time for the SSRS Report Manager
website? It is my understanding that the first time you access the site
(http://localhost/reports), SSRS has to compile all of the corresponding
..aspx pages behind the scenes first, then the subsequent load times of the
page are much quicker. Is there a way to improve this so none of our users
have to wait for this? For instance, can we schedule this to happen at a
certain time, so they will be available for the first user, and they will not
have to wait?

Thanks,
--

Re: Improve inital load time of Report Manager webstie

Bruce L-C [MVP]
8/28/2007 2:29:25 PM

Go to IIS Manager, under Applocation Pools node, right click
"DefaultAppPool" in which the Reporting Server work process is running,
select properties. On "Performace" tag, you will see, by default, the app
pool will shut down if > being idle for 20 min. You can extend this time to
8x60min 480min, so that the app pool will not shut down for a regular
working day. However, the first report reader of the day, will hit the
delay. You may schedule a dummy report at beginning of a work day for this.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]