Showing posts with label known. Show all posts
Showing posts with label known. Show all posts

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

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