
I've noticed that SSRS recycles its AppDomain daily. For some reason, it's taken to doing this at 10:18 am in the morning, and any reports that are running at the time (10-11 am is peak hours) are crashed.
SSRS is installed on the same box as SQL Server, but IIS is not installed, so I'm not able to go into the IIS manager and change the Application pool settings to recycle at a specific time. I'm not even 100% certain the Application pool and the AppDomain are one and the same.
Does anyone know how to control how often or at least specifically when SSRS recycles its AppDomain? Ideally, I need to move it to a less obnoxious time of day or day or the week.
*This post is locked for comments
I have the same question (0)I found a technet article covering the recycle behavior of SSRS.
[View:https://technet.microsoft.com/en-us/library/bb934330.aspx:750:50]
The default RecycleTime parameter in rsreportserver.config file is 720 minutes or 12 hours. It looks like there's no way to schedule a specific time of day, but apparently the clock starts ticking when the service is started. I must have restarted the service at 10:18 am or 10:18 pm at some point in the past, and it's been lined up on that point in time ever since.
The article states that "Requests already in progress are allowed to complete in the current application domain until the wait time expires.", but clearly that's not true. The default MaxAppDomainUnloadTime is 30 minutes, and it's clearly not waiting even a few seconds for running reports to finish.
Others are suggesting that a scheduled service restart at a strategic time is the best way to handle this problem.
[View:http://www.adamkreul.com/archive/2013/11/configuring-the-recycletime-ssrs-setting/:750:50]
"When the reporting services service is restarted, it recycles the application domains as well. This also resets the ‘RecycleTime’ timer, and you’re good for another 12 hours. After fighting this issue for a while, we decided to schedule a job that restarts of the reporting services service outside of business hours,"