Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS - Process dies/goes to sleep after not being used

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.

like image 252
Roy Rico Avatar asked Aug 19 '08 03:08

Roy Rico


2 Answers

For anybody using the integrated webserver that is built into SQL Reporting Services (and hence IIS may not even be installed on the box), the setting to control this actually lives in:

C:\Program Files\Microsoft SQL Server\
         MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config

Your directory may be different; version 10_50 maps to SQL 2008 R2.

You'll be looking for the setting called RecycleTime.
Default is 720 (12 hours). Setting it to 0 will disable.

like image 153
Lynn Crumbling Avatar answered Sep 21 '22 09:09

Lynn Crumbling


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.

like image 22
Daniel Auger Avatar answered Sep 22 '22 09:09

Daniel Auger