AWE and Target Server Memory

Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
This is the script we used to enable AWE and set Max Memory, essentially
leaving 2GB for the OS.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Just so you are aware, we do have the boot.ini with the PAE and 3GB switches
set.
The question I have, is what I am seeing for Target and Total Server Memory:
Target Server Memory(KB) = 4087767
Total Server Memory(KB) = 4087747
I was expecting to see more Target Server Memory being used (closer to 6GB)
rather than only 4087767KB / 3.898GB.
Please explain.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200609/1Hi,
Do you see the Linch's message ?
This is a SQL Server 2000 Bug after you install SP4, Microsoft recommend
apply following patch:
http://support.microsoft.com/defaul...kb;en-us;899761
Run the following command for see memory status in SQL Server 2000:
DBCC MEMORYSTATUS
For more information see the following KB:
http://support.microsoft.com/?id=271624
Regards,
Rodrigo Fernandes
"cbrichards via droptable.com" wrote:

> Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
> This is the script we used to enable AWE and set Max Memory, essentially
> leaving 2GB for the OS.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> Just so you are aware, we do have the boot.ini with the PAE and 3GB switch
es
> set.
> The question I have, is what I am seeing for Target and Total Server Memor
y:
> Target Server Memory(KB) = 4087767
> Total Server Memory(KB) = 4087747
> I was expecting to see more Target Server Memory being used (closer to 6GB
)
> rather than only 4087767KB / 3.898GB.
> Please explain.
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200609/1
>