If you experience the following error when your ASP.NET application connects to the MS SQL server:
System.InvalidOperationException: Timeout expired. The timeout period
elapsed prior to obtaining a connection from the pool. This may have
occurred because all pooled connections were in use and max pool size
was reached.
you have depleted database connections in the connection pool.
To resolve the issue, you should:
1. Check your application to make sure all database connections are
closed when they are not needed. ASP.NET has a garbage collector to
reclaim unused resources, however, on a busy site it is likely that the
connection pool will run out of connections before garbage collection
kicks in.
2. You can raise the connection pool size in the connection string. For
example, you can add "Max Pool Size=100" to your connection string to
increase the pool size to 100.
Article ID: 119, Created: July 5, 2012 at 2:38 AM, Modified: July 5, 2012 at 2:38 AM