amalin_chatterjee (10/24/2008)

---

Hi,

this is my first query to the forum.

one of our applications (.net web app) throws the following error frequently

"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."

the above was due to open connections in the code. The same was handled by adding finally & using blocks.

We also want to increase the pool size. Currently we have not specified the pool size in the connection string.

Question

1. what is the default Pool size.

2. What is the maximum pool size which can be specified.

3. should some setting be done in SQL 2005 server or specifying the size in application connection string is enough

4. Most important. What can be the impacts (negative, overheads) of increasing connection pool on the application (specially a web app)