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!
Leon
Do 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 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!
>Leon
>

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
>