How To remove the timeout expired and connection pooling problem

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;