RE: Weird caching problem.
- From: "Ball, Dan" <DBall@xxxxxxxxxxx>
- To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
- Date: Thu, 10 Feb 2005 13:25:22 -0500
Thanks, I'll do that tonight and reboot it afterwards.
Do you know if the amount of CPU utilization is directly correlated to
amount of memory allocated? I have 4GB of physical memory, and it
seemed to be working great with about 1GB in use by the SQL service.
Now that it using a bit more memory, it seems to also be utilizing more
of the CPUs time.
-----Original Message-----
From: Jim Harrison [mailto:Jim@xxxxxxxxxxxx]
Sent: Thursday, February 10, 2005 11:04
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.
Other related posts:
