Solved

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

Posted on 2013-06-06
4
997 Views
Last Modified: 2013-06-07
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
Comment
Question by:wrenmott
  • 2
  • 2
4 Comments
 
LVL 19

Expert Comment

by:Rimvis
ID: 39225351
Hi wrenmott,

There is RecycleTime parameter in the config file:
http://msdn.microsoft.com/en-us/library/ms157273%28v=sql.110%29.aspx
0
 
LVL 1

Author Comment

by:wrenmott
ID: 39225808
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
 
LVL 19

Accepted Solution

by:
Rimvis earned 500 total points
ID: 39228155
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
 
LVL 1

Author Comment

by:wrenmott
ID: 39228475
Excellent!  Everything I needed to know and more.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now