Roman's Weekly SQL Server Tip - How to keep the Reporting Services application loaded
If you work with Reporting Services, you probably noticed how long it takes to start Report Manager after a period of inactivity. One of the reasons for this is that it actually needs to initialize and load two applications (RM is an ASP.NET web application and the backend Report Server is a web service). You can keep the application loaded in Windows 2003 Server if you open the application pool seettings and uncheck “Shutdown worker process after being idle for...”. After you do this, any web application that uses the application pool will remain loaded.