June 17, 2003 02:17 PM

The .NET Connection Pool Lifeguard

Prevent pool overflows that can drown your applications
Rating: (0)
SQL Server Magazine
InstantDoc ID #39031
Most ADO.NET data providers use connection pooling to improve the performance of applications built around Microsoft's disconnected .NET architecture. An application opens a connection (or gets a connection handle from the pool), runs one or more queries, processes the rowset, and releases the connection back to the pool. Without connection pooling, these applications would spend a lot of additional time opening and closing connections.

Whe...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Using "CommandBehavior.CloseConnection" as argument for ExecuteReader() does close its associated connection, if you close the DataReader yourself (with Close()) after finishing with reading.

J. Kuiper 6/28/2004 6:23:56 AM


It would be great if you covered something about "how to deal with a full connection pool?" How can we flush the connections in a connection pool?
Thanks

Druay AKAR 4/7/2004 4:04:36 PM


Very useful article. I have a problem with an application that is levaing orphaned connections but I haven't found the way to get rid off them. I've done all the different things you mentioned in the article but the problem persist. Is there any programatically way to kill of these orphaned connections?

Alexander Gomez Piedra 3/29/2004 11:07:44 AM


I found the article to be very information and enlightening.
Gave some good advice on how to avoid the pitfalls of connection pooling.

Overall, an excellent read. :-)

yasir3/9/2004 6:24:14 AM


Thank you very much. Our department is migrating to .Net from VB6 and we have been floundering, mainly over connection pooling. These two articles are the only ones we found that give complex examples and in-depth discussion. Now we finally understand why we were getting pool overflow--and what to do about it.

Raymo 2/27/2004 11:08:03 AM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS