Wednesday, July 31, 2013

Connection Pooling and connection leak

Yes, we have a full pool issue.


When testing this today, we notice that every click that is made increases the open connections on SQL Server but doesn't close them. Eventually, the connections are closed after about 5+ minutes.


All of our data access methods use the above code to get or write data. We thought that using the "Using()" statement would close the connection. But perhaps the connection has to be made in the Using() statement and not call another method that returns the connection?


No comments:

Post a Comment