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.

ReportSeverConfig

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 system.net.webClient
$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 system.net.webClient
$cred = [System.Net.CredentialCache]::DefaultNetworkCredentials
$wc.Credentials = $cred
$src = $wc.DownloadString("
http://yourserver/Reports/Pages/Folder.aspx")

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

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: