Warm up Script for SQL 2008 Reporting Services

By Tracey BrinkmanGP Reporting, Microsoft Dynamics GP, SSRS Report, , With 0 comments

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

 

webObj.send

Then setup a scheduled task to execute the vbs script in a frequent interval.

Create Basic Task Wizard

Edit Trigger

Note: Above script is not a Microsoft recommended solution. Use it at your own risk.