SSRS – MS Reporting Services – Recycle times

When accessing the SSRS web page the first time in the morning, this can be frustrating that the first users have to wait a long time before they can see the reporting service home page.

Many posts have been logged on the internet about this but there is descend solution except these workarounds

Step 1

Change the <RecycleTime>1440</RecycleTime> in the C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer/rsreportserver.config file.


Don’t forget to restart the reporting service after applying the change.

If this does not help and it won’t ! You will have to move to the final workaround.

Step 2

Make a Powershell script that will restart the service and trigger the reporting service home page.

Stop-Service "SQL Server Reporting Services (MSSQLSERVER)"
Start-Service "SQL Server Reporting Services (MSSQLSERVER)"

$wc = New-Object
$cred = [System.Net.CredentialCache]::DefaultNetworkCredentials
$wc.Credentials = $cred
$src = $wc.DownloadString("http://srvplsk02/Reports/Pages/Folder.aspx")

This will do the job, but again not in our case ! Sad smile

We noticed that even running this script daily at 2 AM it would work throughout the morning for about 8 hours and then again the long wainting time came along.

So a second script was needed to mimic the user activity, which I scheduled every 2 hours.

$wc = New-Object
$cred = [System.Net.CredentialCache]::DefaultNetworkCredentials
$wc.Credentials = $cred
$src = $wc.DownloadString("

Finally everything ran fine so far !! I Can’t understand why this most frustrating event was not fixed by MS in the first place.

One Response to SSRS – MS Reporting Services – Recycle times

  1. kiquenet says:

    Any sample ps1 script to modify Recycletime value ?

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: