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

|||

I have added a blog post that shows how to address this issue using subscriptions:

http://blogs.msdn.com/lukaszp/archive/2007/09/18/keeping-your-report-servers-awake-or-no-more-waiting-for-report-server-to-startup.aspx

-Lukasz

No comments:

Post a Comment