views:

348

answers:

3

Another SSRS question here: We have a development, a QA, a Prod-Backup and a Production SSRS set of servers. On our production and prod-backup, SSRS will go to sleep if not used for a period of time. This does not occur on our development or QA server. In the corporate environment we're in, we don't have physical (or even remote login) access to these machines, and have to work with a team of remote administrators to configure our SSRS application. We have asked that they fix, if possible, this issue. So far, they haven't been able to identify the issue, and I would like to know if any of my peers know the answer to this question. Thanks.

A: 

I vaguely recall having problems with SSRS on one machine when we changed the "Enable HTTP Keep-Alives" setting in IIS. Try toggling that checkbox (I don't remember whether it was checked or unchecked when it caused us problems).

Matt Hamilton
+1  A: 

In IIS, check the settings on the application pool that SSRS is running in. On the properties pane->Performance tab you can set the amount of time the worker process needs to be idle for before it shuts down. You can also disable this entirely.

Daniel Auger
A: 

I assume the answers are for SSRS 2005 as SSRS 2008 does not use IIS

Anyone have idea for SSRS 2008 not going to sleep? someone asked the question here also http://stackoverflow.com/questions/2599977/ssrs-2008-resuming-from-sleep

jerryhung