Wednesday, March 7, 2012

Report Server goes to sleep....zzzzzzz

The known issue about the report server going to sleep after being idle for a while is causing me a problem. I have set up a dummy sibscription to create and email a report every hour and also have set the IIS setting on the application pool the RS uses (shut down worker process after being idle for x mins, I have set this to 860!).

But the report server still goes to sleep and it can take up to 60 seconds for a report to start up.

What else can I set to reduce this problem?

If reporting service has to perform quickly I ussually copy the setting of the apppool from Sharepoint. These apppool are configured to recycle at a given time (tab 1) and no recycle after some minutes (tab 2).

Hope this would help you.

|||I dont have Sharepoint, is its application pool set to never recycle?|||

On Windows 2003 / IIS 6, I believe the default setting is that application pools are reset by IIS after 20 minutes of idle time.

-- Robert

No comments:

Post a Comment