SSRS will go to sleep after about 20 minutes of no-one using it. The next person who uses it will wait for about a minute for SSRS to wak eup before their report starts to run.
Most of the information on the web about how to overcome this relates to SSRS 2005 and it not relevant to SSRS 2008 and above. I have tried the Recycle Time change suggested in the previous post, but it merely delays when SSRS goes to sleep.
Something I have done at one place I worked at that gets around the problem is to set up a SQL Agent job that runs every 10 minutes and opens a report.
I do not have the code available so cannot send it to you, but Google can find you details of how to open a report in a command line, and you can probaby work out how to put that command line into a SQL Agent job.
The end result of this is that SSRS is kept alive and ready to run reports all the time. SSRS will do a forced close about once every 24 hours to release any memory that has leaked, but the SQL Agent job will often get it back before anyone notices.
Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017
: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara