Win2003 / Sql2000 Memory usage

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

Re: Win2003 / Sql2000 Memory usage

michael (mharen@gmail.com) writes:
> 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).

You do indeed need to add the /3GB switch in BOOT.INI. Else the operating
system will claim 2GB for its own purposes.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx