How to detect SqlServer connection leaks in a ASP.net applications?
I’m currently doing some GUI testing on a ASP.net 2.0 application.
The RDBMS is SQL Server 2005. The host is Win Server 2003 / IIS 6.0.
connection-pooling
How to find leaking db connection pool handle?
I’m seeing the dreaded “The timeout period elapsed prior to obtaining a connection from the pool” error.
Closing a conneciton in the “unload” method
I have inherited a web framework whereby the previous developer has opened and closed his database connections in the init/unload methods of the page life cycle. Essentially constructor is like this (simplified to demonstrate the point);