Configuring and using PAE on SQS Server 2000 Enterprise Edition

We are running SQL Server 2000 Enterprise Edition on a Windows Server 2003
machine with 16 GB of memory. I am trying to use more than the default 2GB o
f
memory for SQL Server.
I have added the /PAE switch to the boot.ini file on the server, configured
SQL Server by issuing a
sp_configure 'show advanced options', 1
RECONFIGURE
and a
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 14336
RECONFIGURE
GO
However, it looks like SQL Server is till using less than 2GB of memory when
running. I have run the sp_configure check on it's own and noticed that the
config_value for AWE enabled is 1, but that the run_value is still 0.
Could that be the problem? What do I have to do to fix this?
I know I did restart the server after adding the settings (the setting for
'show advanced options' and 'max server memory' both show the same value for
config and run_value. It is just the AWE enable setting that has a
discrepancy.
Should I set the 'max server memory' to less than 14 GB if the server has
16GB available? How much does the OS need?
Thanks
FredHow to configure memory for more than 2 GB in SQL Server
http://support.microsoft.com/defaul...;274750&sd=tech
Managing AWE Memory
http://msdn.microsoft.com/library/d...>
ver_1fnd.asp
AMB
"fredscuba" wrote:

> We are running SQL Server 2000 Enterprise Edition on a Windows Server 2003
> machine with 16 GB of memory. I am trying to use more than the default 2GB
of
> memory for SQL Server.
> I have added the /PAE switch to the boot.ini file on the server, configure
d
> SQL Server by issuing a
> sp_configure 'show advanced options', 1
> RECONFIGURE
> and a
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', 14336
> RECONFIGURE
> GO
> However, it looks like SQL Server is till using less than 2GB of memory wh
en
> running. I have run the sp_configure check on it's own and noticed that th
e
> config_value for AWE enabled is 1, but that the run_value is still 0.
> Could that be the problem? What do I have to do to fix this?
> I know I did restart the server after adding the settings (the setting for
> 'show advanced options' and 'max server memory' both show the same value f
or
> config and run_value. It is just the AWE enable setting that has a
> discrepancy.
> Should I set the 'max server memory' to less than 14 GB if the server has
> 16GB available? How much does the OS need?
> Thanks
> Fred|||Hi
Before you set AWE you need to set "Lock Pages In Memory" first.
How to set the "Lock Pages In Memory", Please see URL
http://msdn.microsoft.com/library/d...r />
_2vqh.asp
By default SQL Seerver 2000 in Windows 2003 is disable.
Goog luck
Bogi Wu
"fredscuba" wrote:

> We are running SQL Server 2000 Enterprise Edition on a Windows Server 2003
> machine with 16 GB of memory. I am trying to use more than the default 2GB
of
> memory for SQL Server.
> I have added the /PAE switch to the boot.ini file on the server, configure
d
> SQL Server by issuing a
> sp_configure 'show advanced options', 1
> RECONFIGURE
> and a
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', 14336
> RECONFIGURE
> GO
> However, it looks like SQL Server is till using less than 2GB of memory wh
en
> running. I have run the sp_configure check on it's own and noticed that th
e
> config_value for AWE enabled is 1, but that the run_value is still 0.
> Could that be the problem? What do I have to do to fix this?
> I know I did restart the server after adding the settings (the setting for
> 'show advanced options' and 'max server memory' both show the same value f
or
> config and run_value. It is just the AWE enable setting that has a
> discrepancy.
> Should I set the 'max server memory' to less than 14 GB if the server has
> 16GB available? How much does the OS need?
> Thanks
> Fred