Was wandering if you were planning to reply with solution on this.
Previously, the application was migrated from ASP.NET 1.1 to ASP.NET 2.0.
What is happening:: ASP.NET 2.0 releases resources slightly different. In 1.1. SQL connection strings were released when the Connection object was garbage collected. However in 2.0 the objects are not released during garbage collection, and the connection is waiting until the SQL server closes the connection (i.e. the connection "times-out"). This keeps a lot of unnecessary connections open.
The fix was pushed to Staging and i need to test it. How do i create multiple connections? Is there a tool for that? We have some Automation tools but i tried them and it does not seem to be working, as it only creates 1 connections based on my Windows user.
Any help would be greatly appreciated.