Posted by michael on 06/20/07 19:45

I have googled by heart out trying to find answers to this and am only
more confused.

DB Server:
Windows Server 2003 Enterprise
4 GB memory
SQL Server 2000 Enterprise Edition, SP4 8.00.2039

The SQL server process appears to be using a steady 1.7 gb of memory.
There are no other memory intensive applications running on this
server as reported by Task Manager.

I have read all about the 2gb/process limit and the /3gb boot switch
and all but most of that seems to apply to windows 2000, not 2003. I'd
like SQLServer to use more of the memory if it can (assuming it would
be advantageous for performance).

Can anyone sum this up for me?

Thanks,
Michael

[Back to original message]