469,354 Members | 2,254 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,354 developers. It's quick & easy.

sql server memory leak

We are running asp (not asp.net) and vb com dll web sites on a machine
which also has sql server 2000 sp3a running and uses Windows Server
2003. We recently migrated from Windows 2000 (same database) where we
had no problems. However on the new machine, despite much being much
more powerful and having the same usage, the box is periodically
grinding to a halt. The cause seems to be sql server using excessive
amounts of memory, it steadily builds up to after a reboot to a high
level. This seems to point in the direction of a memory leak, is
anyone aware of any such problems with asp/sql server on windows 2003
and how to diagnose/fix them. I am aware of some unclosed connections
in the asp code and objects that have not be set to nothing but this
did not seem to cause a problem in the old machine and it is not
practical to fix them all in the short term. I thought it might be
unclosed connections although when I looked at SQL Server:General
Statistics and User Connections I did not seem to see a large or
increasing number of connections.
Jul 19 '05 #1
0 1697

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by Bardolator | last post: by
8 posts views Thread by ranjeet.gupta | last post: by
4 posts views Thread by Don Nell | last post: by
20 posts views Thread by jeevankodali | last post: by
23 posts views Thread by James | last post: by
3 posts views Thread by Jim Land | last post: by
22 posts views Thread by Peter | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.