database connection leak

Hello,

I am having issues with this unhandled error dealing with the fact that max pool has been reached so server timed out. I have added to my connection string a Max Pool Size="100" but a couple hours later was visited by the same issue at around 2:00 PM.

I suspect a bad module somewhere in my web application which is dotnetnuke and that it is improperly closing database connections after opening them. During higher traffic tmes it seems to occur more as more users obviously are using the web application at the same time.

I was wondering if you guys had any familarity with this in terms of troubleshooting the situation. Is their any querey I could do against the live mssql database vis ssmse that would possibly give me some insight as to what modules or what area of the web app was problematic.

Perhaps a way to invoke pool manager or perhaps some script that would list for me all database connections that were currently open at the time of the querey so I could get some analytics on the issue. Maybe even something that would go further and give me the times they were opened and how long they were left open before closing. Or perhaps stats on the time a connection was opened until the time garbage collection occured.

Any help like this would be appreciated thanks a lot for checking out this post

Bo