Wake up script for SSRS

Question

_{Wednesday, December 4, 2013 4:50 AM}

Hello,

I am using wake up script for my project server 2010 farm from http://sharepointryan.com/2011/03/29/warming-up-sharepoint-2010-using-powershell/ and it’s working fine,

Few question I wanted to ask here are

1-      Is it a good practice to have some wake up script for SSRS or reporting engine? Will that do any good too?

2-      If yes, Adding report server URL in the above mentioned script will be good enough?

3-      What about the url for report server? If I just add web service url ( http://servername/report_server:8080) from report server configuration manager, will that be good enough ?

Please share some script that you have tested in your farm for wake up SSRS?

Thanks

All replies (11)

_{Thursday, December 5, 2013 7:05 PM ✅Answered}

You just need to JIT the page that displays the RDL. That is where the slowness comes from on the initial hit of the page. Waking up the Report Manager URL won't do any good as it is the controls on the page the user views that are important.

Trevor Seward, MCC

Follow or contact me at...
  

This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

_{Sunday, December 15, 2013 10:35 PM ✅Answered}

If the other 19 have different controls, you'll need to wake them up.

Trevor Seward, MCC

Follow or contact me at...
  

This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

_{Wednesday, December 4, 2013 5:02 AM}

SSRS is a system service anyhow. As long as you touch on pages in use by the Reporting Services viewer, they'll be JIT'ed. I don't see any point in attempting to wake up the ReportServerUrl.

Trevor Seward, MCC

Follow or contact me at...
  

This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

_{Wednesday, December 4, 2013 5:06 AM}

i dont see any harm in waking up the SSRS.it always save time, means improve performance.

check this script, it wakeup the report server.

you can also think about the recycling time, by default its 720(12hr) you can increase this.

http://technet.microsoft.com/en-us/library/ms157273.aspx

or if you want something on the SSRS server:

http://www.sqlservercentral.com/Forums/Topic568045-149-1.aspx#bm1022372

Please remember to mark your question as answered &Vote helpful,if this solves/helps your problem. ****************************************************************************************** Thanks -WS MCITP(SharePoint 2010, 2013) Blog: http://wscheema.com/blog

_{Wednesday, December 4, 2013 5:10 AM}

That is for SSRS native mode. You just need to JIT the SSRS pages supplied by the Reporting Services SharePoint Add-in.

In general, "warming up" SharePoint is a waste of memory and of very limited utility (only helps with the initial load of an assembly).

Trevor Seward, MCC

Follow or contact me at...

This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

_{Wednesday, December 4, 2013 3:12 PM}

In our case I was able to make users happy complaining about the slowness at 9 am every day, there are few users who are accessing reports and reporting slowness at first browse only. so I was wondering if we can do some script  like warm up for SSRS?

_{Wednesday, December 4, 2013 4:16 PM}

check this script http://gallery.technet.microsoft.com/scriptcenter/SSRS-Wake-Up-Call-b2026b2c

or this one http://sharepointryan.com/2011/03/29/warming-up-sharepoint-2010-using-powershell/

Please remember to mark your question as answered &Vote helpful,if this solves/helps your problem. ****************************************************************************************** Thanks -WS MCITP(SharePoint 2010, 2013) Blog: http://wscheema.com/blog

_{Thursday, December 5, 2013 7:04 PM}

Hi Waqas,

Thanks for sharing those links. I have those links but the question is how important it is to wake up SSRS and will setting up url from report server configuration will be good enough.

But it seems like as mentioned above if we just set up a script to wake up a page that has .rdl on it, report server will be up as well. If this is not right that I guess we need to go with second option (i.e. set up script for SSRS)

We are testing this in our farm and post the difference.

Thanks again.

_{Sunday, December 15, 2013 10:16 PM}

One more questions regarding the same, I find most of the scripts are to wake up at site collections. E.g. script mentioned above will automatically find all site collections in all web applications.

What if I have 20 aspx pages in library, called pages library and one of them is set to as home page for site collection. e.g. http://servername/pwa/home.aspx . Do I need to wake up/warm up other 19 pages in this library for fat access for user in the morning? Ot waking up at site collection level will be good enough for all the pages in the library?

 Thanks

_{Sunday, December 15, 2013 10:18 PM}

You need to touch on any page with controls that need to be initialized.

Trevor Seward, MCC

Follow or contact me at...
  

This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

_{Sunday, December 15, 2013 10:34 PM}

Are you saying warming up home.aspx will be enough. other 19 pages might  have different controls/webparts?