memory Leak

I have implemented a content management system through ASP and XML files. I am using sessions for my login information. It is a fairly complex site and uses various personal options for clients like, my page, my setting and my e-cards. The database for the clients is kept on MS SQL server. ANd I am using ADODB to connect at various stages.
The problem is that when more than 10 people try to access the site at the same time, irrespective of which part they access, the site hangs and goes down. When I monitor the server for the problem, the memory free goes tremendously high, even for small no of connections. The connections keep on increasing at a fast pace till the website crashes and there are no more connections that can be added. I am currently trying the strategy of timeouts (decreasing them at various portions of the code) and also checking whether there are any open connections. But I am not able to check how many clients are ACTUALLY connected. I read Response.isClientConnected is a strategy.

Please enlighten me on the same. If you know of any strategies to check why this problem might be occuring, please let me know. All views are welcome....

Thank you

Ankush Sharma

What OS are you running? If you are using W2K Pro or XP Pro there is a 10-connection limit in IIS.

If you are on a server DB, certain code errors can cause high memory usage, and storing objects like connection objects in session or application variables is not a good idea.

This page has some useful tips

http://msdn.microsoft.com/library/d...tml/ASPtips.asp