Check to see if you limited the amount of memory SQL uses. You can do this in the SQL Enterprise manager.
Thank you. I hope this information is helpful.
Tim Coffey [MSFT]
This posting is provided “AS IS” with no warranties, and confers no rights. You assume all risk for your use. © 2001 Microsoft Corporation. All rights reserved.
--------------------
| From: scott_mcarthur2003.DeleteThis@yahoo.co.uk
| Newsgroups: microsoft.public.inetserver.iis
| Subject: unclosed connections problem
| Date: 20 Nov 2003 09:46:56 -0800
| Organization: http://groups.google.com
| Lines: 9
| Message-ID: <92c92d63.0311200946.6b987803.DeleteThis@posting.google.com>
| NNTP-Posting-Host: 194.201.25.22
| Content-Type: text/plain; charset=ISO-8859-1
| Content-Transfer-Encoding: 8bit
| X-Trace: posting.google.com 1069350416 13406 127.0.0.1 (20 Nov 2003 17:46:56 GMT)
| X-Complaints-To: groups-abuse.DeleteThis@google.com
| NNTP-Posting-Date: Thu, 20 Nov 2003 17:46:56 +0000 (UTC)
| Path: cpmsftngxa07.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!news-
spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews1.google.com!not-for-mail
| Xref: cpmsftngxa07.phx.gbl microsoft.public.inetserver.iis:284355
| X-Tomcat-NG: microsoft.public.inetserver.iis
|
| We have just migrated from a windows 2000 server running classic
| asp/sql server web sites without the .net framework installed to
| windows 2003. Despite having the same traffic levels sql server on the
| new machine seems to be using up much more RAM than before. I suspect
| that their may be unclosed database connections in the asp code and
| that the reason is that windows 2003 is not shutting down unused
| connections as quickly. Is this feasible? If so is their any
| workaround as it might take some time to fix all the connections in
| the code.
|
FAQ
Profile
Private Messages
Log in
