There's no "global" correlation between memory and CPU usage. You have to examine each case on its own merits. -----Original Message----- From: Ball, Dan [mailto:DBall@xxxxxxxxxxx] Sent: Thursday, February 10, 2005 10:25 AM To: [ISAserver.org Discussion List] Subject: [isalist] RE: Weird caching problem. http://www.ISAserver.org 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. ------------------------------------------------------ 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: jim@xxxxxxxxxxxx To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist Report abuse to listadmin@xxxxxxxxxxxxx All mail to and from this domain is GFI-scanned.