Posted by Erland Sommarskog on 06/20/07 21:17

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/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Read Backup File Directly?
• Prev in forum: Re: Can SQL Lose Records?
• Thread view: Re: Win2003 / Sql2000 Memory usage

[Reply to this message]