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;
Highlight the report you wish to improve the performance for, and select Manage;
Select Cache Refresh Options;
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;
The details should be confirmed after clicking Ok;
Wait for the first interval to pass, and then test.