Configuring memory for SQL 2000

I'm planning to install SQL Server 2000 Enterprise Edition on Windows Server
2003 Standard Edition machine with 8Gb of memory.
How do I force SQL server to use at least 6Gb out of 8Gb?
Thank you in advance!
LeonDo you mean "at least 6GB" or "up to 6GB"? Either way you'll need the
/pae switch in boot.ini. This allows the OS to see more than 4GB of
physical memory. Then turn on AWE memory and set the min & max memory
settings in SQL Server as appropriate with the sp_configure proc.
For between 6GB and 7GB:
exec sp_configure 'awe enabled', 1
exec sp_configure 'min server memory', 6144
exec sp_configure 'max server memory', 7168
-- then stop & restart the server (needed for the awe enabled option)
For anything up to 6GB:
exec sp_configure 'awe enabled', 1
exec sp_configure 'max server memory', 6144
-- then stop & restart the server (needed for the awe enabled option)
Hope this helps.
*mike hodgson*
http://sqlnerd.blogspot.com
Leon Shargorodsky wrote:

>I'm planning to install SQL Server 2000 Enterprise Edition on Windows Serve
r
>2003 Standard Edition machine with 8Gb of memory.
>How do I force SQL server to use at least 6Gb out of 8Gb?
>Thank you in advance!
>Leon
>