8 GB of RAM installed

SQL Server 2000 Enterprise Edition machine running Windows 2000 Advanced Ser
ver. The server has 8 GB of RAM installed but for some reason SQL Server is
only utilizing less than 4 GB. What would the likely cause be?Three thoughts:
You are not using /3GB /PAE within the boot.ini
You have not configured SQL Server to with the "awe enabled" option (exec
sp_configure).
Memory usage is being restricted by min server memory (MB) and max server
memory (MB) (exec sp_configure).
Keith
"Serverdba" <Serverdba@.discussions.microsoft.com> wrote in message
news:A4DAD1E0-5C6A-49D4-8631-6DE54777B44B@.microsoft.com...
> SQL Server 2000 Enterprise Edition machine running Windows 2000 Advanced
Server. The server has 8 GB of RAM installed but for some reason SQL Server
is only utilizing less than 4 GB. What would the likely cause be?|||Are you using the /3GB in your boot.ini? Look in books online under
"Managing AWE Memory."
-John Oakes
"Serverdba" <Serverdba@.discussions.microsoft.com> wrote in message
news:A4DAD1E0-5C6A-49D4-8631-6DE54777B44B@.microsoft.com...
> SQL Server 2000 Enterprise Edition machine running Windows 2000 Advanced
Server. The server has 8 GB of RAM installed but for some reason SQL Server
is only utilizing less than 4 GB. What would the likely cause be?|||All those option is set. Still same problem
"John Oakes" wrote:

> Are you using the /3GB in your boot.ini? Look in books online under
> "Managing AWE Memory."
> -John Oakes
> "Serverdba" <Serverdba@.discussions.microsoft.com> wrote in message
> news:A4DAD1E0-5C6A-49D4-8631-6DE54777B44B@.microsoft.com...
> Server. The server has 8 GB of RAM installed but for some reason SQL Serve
r
> is only utilizing less than 4 GB. What would the likely cause be?
>
>|||Did you reboot after changing boot.ini?
-John Oakes
"Serverdba" <Serverdba@.discussions.microsoft.com> wrote in message
news:188FFB29-DDE5-42B3-A802-DC671FC7B68A@.microsoft.com...[vbcol=seagreen]
> All those option is set. Still same problem
> "John Oakes" wrote:
>
Advanced[vbcol=seagreen]
Server[vbcol=seagreen]|||You also need the /PAE set in the Boot.ini.
Andrew J. Kelly SQL MVP
"Serverdba" <Serverdba@.discussions.microsoft.com> wrote in message
news:188FFB29-DDE5-42B3-A802-DC671FC7B68A@.microsoft.com...[vbcol=seagreen]
> All those option is set. Still same problem
> "John Oakes" wrote:
>
Advanced[vbcol=seagreen]
Server[vbcol=seagreen]|||Serverdba wrote:

> SQL Server 2000 Enterprise Edition machine running Windows 2000 Advanced Server. T
he server has 8 GB of RAM installed but for some reason SQL Server is only utilizing
less than 4 GB. What would the likely cause be?
Hi,
The Account which starts the SQL Service must have the privilege "lock
pages in memory" - you can set this in the local policy settings