• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1160
  • Last Modified:

Scheduling the Recycling of HTTP.sys (or SSRS AppPool) in SSRS 2012

Hi all -

We recently discovered that our SSRS AppPool is recycling at an inopportune time on the default 12 hour schedule.  I would like to change time it recycles itself.  Obviously, because it is controlled through HTTP.sys rather than full blown IIS I can not use the GUI, or so it would appear, to make the change.  There's probably an APPCMD utility to do it but I am having difficulty tracking it down.

What we would like is to have it recycle itself once a day at 3am.

Any help much appreciated.

Kind regards,


Wren
0
wrenmott
Asked:
wrenmott
  • 2
  • 2
1 Solution
 
RimvisCommented:
Hi wrenmott,

There is RecycleTime parameter in the config file:
http://msdn.microsoft.com/en-us/library/ms157273%28v=sql.110%29.aspx
0
 
wrenmottAuthor Commented:
Got it!  However, now that I can set the interval I need to know how to tell it at what time to start.  Currently it runs at 8am and 8pm.  We just want it to run once (configurable through RecycleTime) at 3am but I don;t see where to give it an actual time, do you?

Cheers!
0
 
RimvisCommented:
Recycle time is calculated from the service restart. So if you want to recycle pool at the specific time, you have to restart the service itself.

Check this article for reference:
http://www.pawlowski.cz/2011/07/solving-issue-long-starting-report-ssrs-2008/
0
 
wrenmottAuthor Commented:
Excellent!  Everything I needed to know and more.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now