Slow SSRS Reports

A query that has come up a few times, is reports in SSRS being slow on loading. Following some investigation, I found the below two steps to be useful. I will say in advance they are not the complete solution to performance issues and I am no SSRS expert, however hopefully they can be of use for some people.

Typical user experience included a slow SSRS site, and the report loading being slow as well.

SSRS Page Slow Loading;
Run this text in PowerShell by either saving to a .PS1 file type using notepad or line by line in PowerShell (modify the URL as well);
$wc = New-Object system.net.webClient
$cred = [System.Net.CredentialCache]::DefaultNetworkCredentials
$wc.Credentials = $cred
$src = $wc.DownloadString(“http://ps2010demo/reports/Pages/Folder.aspx“)

This text should be setup as a windows scheduled task, every 15 minutes.

SSRS Reports Slow Loading;
On SQL, ensure the SQL Server Agent is started and set to Automatic;

SSRSSlow1

Highlight the report you wish to improve the performance for, and select Manage;

SSRSSlow2

Select Cache Refresh Options;

SSRSSlow3

Select New Cache Refresh Plan in the previous screenshot, and then populate the details for a 15 minute schedule including a suitable time for the first job to start. It maybe a good idea to set this time 5 minutes after the PowerShell script scheduled task;

SSRSSlow4

The details should be confirmed after clicking Ok;

SSRSSlow5

Wait for the first interval to pass, and then test.

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