title: Is there a way to stop SQL Express 2008 from Idling?
body: <p>I am using SQL Express 2008 as a backend for a web application, the problem is the web application is used during business hours so sometimes during lunch or break time when there is no users logged in for a 20 minute period SQL express will kick into idle mode and free its cache.</p>
  
  <p>I am aware of this because it logs something like:</p>
  
  <blockquote>
    <p>Server resumed execution after being idle 9709 seconds  </p>
  </blockquote>
  
  <p>or  </p>
  
  <blockquote>
    <p>Starting up database 'xxxxxxx'
    in the event log</p>
  </blockquote>
  
  <p>I would like to avoid this idle behavior. Is there anyway to configure SQL express to stop idling or at least widen the time window to longer than 20mins? Or is my only option to write a service that polls the db every 15mins to keep it spooled up ?</p>
  
  <p>After reading articles like <a href="http://blogs.msdn.com/sqlexpress/archive/2008/02/22/sql-express-behaviors-idle-time-resources-usage-auto-close-and-user-instances.aspx" rel="nofollow noreferrer">this</a> it doesn't look to promising but maybe there is a hack or registry setting someone knows about.</p>