15 Seconds : Tuning Up ADO.NET Connection Pooling in ASP.NET Applications

Connection Pooling Basics

Intel Atom Developer – CEP Premium
Enter your netbook app into the Intel® Atom™ Developer Challenge by 6/ 14.
appdeveloper.intel.com/challenge
AutoCAD® Trial Download
Free 30 Day Trial Of AutoCAD 2011. Save Time And Increase Productivity
Autodesk.com/AutoCAD
Microsoft SQL Server® 2008 – Free Trial
Download the Free 180-day Trial of SQL Server® 2008 Enterprise Edition!
Microsoft.com/EverybodysBusiness

Opening a database connection is a resource intensive and time consuming operation. Connection pooling increases the performance of Web applications by reusing active database connections instead of creating a new connection with every request. Connection pool manager maintains a pool of open database connections. When a new connection requests come in, the pool manager checks if the pool contains any unused connections and returns one if available. If all connections currently in the pool are busy and the maximum pool size has not been reached, the new connection is created and added to the pool. When the pool reaches its maximum size all new connection requests are being queued up until a connection in the pool becomes available or the connection attempt times out.