title: Connection Pooling and Multiple Connection Strings
body: <p>An ASP.NET 3.5 application has two connection strings:</p>
  
  <pre><code>Data Source=RedDB;Initial Catalog=Red;User Id=myuser;Password=pas;Max Pool Size=50;Min Pool Size=1
  
  Data Source=BlueDB;Initial Catalog=Blue; User Id=myuser;Password=pas;Max Pool Size=375;Min Pool Size=2
  </code></pre>
  
  <p>Suppose the RedDB connection has a stored procedure that is hanging indefinitely due to a bad index. </p>
  
  <ol>
  <li><p>If the application does not close the RedDB connection properly (viz., with a try/finally block), how quickly do the pool connections get recycled as users are hitting the site?</p></li>
  <li><p>If the RedDB connection pool is maxed out because of users getting the SQL timeout, does that have ANY impact on the BlueDB, or is that a completely isolated connection pool?</p></li>
  </ol>