Warm up Script for SQL 2008 Reporting Services
April 21 |
By Ryan McBee
In SSRS 2005, after a period of inactivity (no calls to Reporting services), the first call to RS is very slow. This is more of an IIS issue than reporting services. The app pool generally winds down if there is no activity for a certain period of time. When the subsequent (first) request comes into reporting services, it has to restart everything hence the slowness.
However, SSRS 2008 no longer uses IIS. I have tried quite a few different ways to speed up SSRS 2008 on the first run, but the one that has worked best is a warm up script as described below.
You will enter the code below in a plain text file, change the path of the SQL Reporting Services Report Manager to the Report Manager Path that you use and save the file with a .vbs extension.
Dim strURL, strFile
Set webObj = CreateObject(“MSXML2.ServerXMLHTTP”)
‘ Replace below URL with the URL of any report in the reporting server
strURL = “http://isolutions/Reports/ ”
webObj.Open “GET”, strURL
Then setup a scheduled task to execute the vbs script in a frequent interval.
Note: Above script is not a Microsoft recommended solution. Use it at your own risk.