Hi
Connection pooling and timeout expired problem occurs due to database connection not closed properly or poolsize and timeout period not set correctly in the database connection string
make sure you are taking care, the followings for database connection string
1. Close database connections where ever necessary, as due to connection leakages also the connection pool problem will occur
using (SqlConnection sqlConnString = new SqlConnection(ConnectionString))
{
sqlConnection.Open();
someCall(sqlConnString);
}
2. Increase the pool size, default maxpool size is 100 and minimum pool size is zero, you can increase pool size appropriately
3.Increase Connect timeout for ex Connect Timeout=5 means 5 seconds
Sample connection string for your reference
sqlConnString=integrated security=SSPI;SERVER=YOUR_SERVER;DATABASE=YOUR_DB_NAME;Min Pool Size=5;Max Pool Size=100;Connect Timeout=5;