Thanks Dale,
I thought there was a way to do this on the fly with an sql command, but
cannot remember how. Doing it in the config requires a reboot or sql
re-start, and I cannot take it down right now.
I would like to try it on the current server to help me determine how much
ram to put in the new one.
Your help is greatly appreciated.
JOhn :}
>> New System:
>> PII 233 - 128MB - 9GB UW SCSI - 3C905B-TX & 10/100MB Hub, etc.
>> How do I tell SQL to use all the ram in the system - ie: 96 to 128 MB ram?
>
>You can tell SQL Server the max amount of ram to use in the
>confgiuration
>its in 2k block. For Example 40000 would be 80mb.
John C. Lange, Sr. PALACE dot NET, INC.
microjl@palacenet.net MICRO-TECH Computers, Inc.
608.742.1601 & 6980 2800 New Pinery Road
http://www.palacenet.net/ Portage, WI 53901
Visit our online store @ http://www.microt.com/
Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html
--- __o
--- _-\<,_ Fastest Service in Town
--- (_)/ (_)