RE: Memory Consumption Of SQL Server
- From: "Ara" <ara@xxxxxxxxxxxxx>
- To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
- Date: Tue, 19 Apr 2005 17:17:06 -0700
Looks like there is a known issue. I had the same problem sql eating my ram and
this fixed it. Worked perfectly for me
-----Original Message-----
From: Jim Harrison [mailto:Jim@xxxxxxxxxxxx]
Sent: Thursday, February 10, 2005 10:04 AM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: Weird caching problem.
http://www.ISAserver.org
Found it:
1 - open a cmd window
2 - type the following:
osql -E -S %computername%\msfw
sp_configure 'show advanced options',1 reconfigure with override
go
sp_configure 'max server memory', nnnn reconfigure with override (where
nnnn is in mb)
go
exit
3 - restart MSDE - note that you'll also have to restart the ISA Firewall
service manually.
..I'd recommend giving MSDE at least 1/3 physical RAM, depending on how much
your system actually has.
-----Original Message-----
________________________________________
From: Wayne Berry [mailto:wayne@xxxxxxxxxx]
Sent: Tuesday, April 19, 2005 9:24 AM
To: [ISAserver.org Discussion List]
Subject: [isalist] Memory Consumption Of SQL Server
http://www.ISAserver.org
ISAList,
I have a dedicated Windows 2003/ ISA 2004 (One Gig of RAM) machine and the SQL
server process is consuming the entire RAM on the machine and even some swap
space on the disk. I turned caching on a couple of days ago, however turned it
off yesterday to try to get my RAM back. Couple of questions:
1) Is the caching done by the SQL Server process?
2) Does ISA 2004 usually cache so much in RAM that it consumes the entire RAM
on the machine?
3) If the issue is caching why doesn't turning caching off clear the SQL server
RAM? I did specify to have ISA Server restart after turning caching off.
-Wayne
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com
Leading Network Software Directory: http://www.serverfiles.com
No.1 Exchange Server Resource Site: http://www.msexchange.org
Windows Security Resource Site: http://www.windowsecurity.com/
Network Security Library: http://www.secinf.net/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
ara@xxxxxxxxxxxxx
To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx
Attention:
This message, including any attachment(s), is intended only for the use of the
individual(s) to which it is addressed and may contain information that is
privileged or confidential. Any other distribution, copying or disclosure is
strictly prohibited. If you are not the intended recipient or have received
this message in error, please notify us immediately by reply e-mail and
permanently delete this message including any attachment(s), without reading it
or making a copy.
Any outgoing message has been scanned for possible harmful file(s) or
script(s), but it is your sole responsibility to run detection tools as we
won't guarantee the safety of message(s).
Other related posts:
