Asp.net ile Sql Server arasındaki connection pool probleminin çözümü

var connection = new SqlConnection(ConnectionString);
try
{
     connection.Open();
}
finally
{
     connection.Close();                
}

veya

using (SqlConnection connection = new SqlConnection(connectionString))
{
     connection.Open();
}

timeout probleminin çözümü: web.config içerisine aşşağıdaki kod eklenir.

<sytem.web>
     <httpRuntime maxRequestLength="20000" executionTimeout="999999"/>
</system.web>

connection string max pool size ayarlanması

<add name="conn" connectionString="Data Source=SN;Initial Catalog=DB;Integrated Security=True;Max Pool Size=50000;Pooling=True;" providerName="System.Data.SqlClient" />