Good question. Sheryl did a little tweaking on it a while back, but we have
since doubled the amount of RAM in the machine to 256.
Looks like it's at 32M/10M right now. Until we can upgrade it, how about
128M dedicated to SQL with a 32M tempdb in RAM. That should leave NT with
enough for itself, no?
> I would just recommend more ram. Up to 512 and give SQL Server like
> 400mb
> of that with a 48mb tempdb in ram. Or just upgrade to SQL 7. :)
::calculating::
That's not too bad. The RAM, that is. Cheaper than SQL 7.
___________________________________
David V. Brenner - dvb@cport.com
International Services Network Corporation
http://www.cport.com
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart