memory leakage

[moleboy]

Anyone???

I taken over an ASP/sql7 database system. Problem is the server has to be reset once a week cause it runs out of virtual memory. I have been told that this is due to memory leakage from the asp connections. Is there any way to monitor the connections to the database or check each page with some freeware???

thanks

 

[SQLSister]

The first thing I would do is talk to your ASP programmers and have them fix their sloppy code. Those connections should be closed when they are done!

 

[chris000]

Windows 2000 ships with Data Access Components (DAC)version v2.5 or 2.6, and these can have problems.

Sounds like it could be a memory leak within the DAC.

According to MS TechNet article Q314638, installing v2.7 of MDAC should fix the problem.

This patch requires a reboot...

see:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q314638