472,096 Members | 1,283 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,096 software developers and data experts.

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 1748

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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.