title: Uncommited transactions when recycling IIS
body: <p>Here's an overview of the problem:
  There's a scheduled job that runs every day at 3 AM that recycles IIS pool.
  During that time, the users face login issues (and some related issues).</p>
  
  <p>I am trying to troubleshoot. I got to know about uncommitted transactions in DB.
  According to my understanding, when IIS application pool gets recycled, a new worker process is created. So, this would mean, that the user will need to re-authenticate himself. 
  Doubt: Will the connection pool be cleared when IIS is restarted?</p>
  
  <p>Assuming that the DB connection pool is not cleared, the same old connection which was not closed will be used to access the DB. Since it's a stale connection (Not sure what it's called), it will not be able to connect with the DB. Right?</p>
  
  <p>The application starts working after 1-2 hours automatically.</p>
  
  <p>I'm guessing that the un-committed transaction would have been killed by then?</p>
  
  <p>Please advise me if I'm heading in the correct direction.</p>
  
  <p>Thank you.</p>