How can I stop SQL Server Reporting Services 2008 going to sleep?

Question

I have SSRS 2008 set-up on a server. All works fine except that if left inactive for a length of time the next time a request is made to the server it takes a long time for it to service it.

I think this is to do with the worker process being shutdown after being idle for a certain length of time. However, as SSRS 2008 isn't managed through IIS I can't find any settings that I can adjust to stop this from happening. In IIS I'd go to the Performance tab of the Application Pool Properties and choose not to shutdown the worker process. How can I do this for SSRS 2008?

Answer 1

The service process in SSRS 2008 can be configured using the RSReportServer configuration file. However I couldn't find any setting in there that controls the idle shutdown timeout.

I guess your only option to keep SSRS from going idle is to have an external process that "pings" it at regular intervals. You could for example post an HTTP request to the Report Manager web application.

Answer 2

Create a report that does nothing. Set a subscription up so that it runs every 'timeout problem duration - 1 minutes'