Memory - PAE, AWE, /3GB

I have a box
windows 2003 ent ed with 8GB or ram
issue is its only seeing 4GB memory and not the 6 I set it at
I set the instance to enable AWE
what am I missing ? /3GB ? /PAE
I want SQL Server to use 6gb and leave 2GB for windows and company
Thanks
I take it you are using SQL 2000 Enterprise Edition which can take advantage
of the PAE switch.
In your boot.ini file enable /PAE, and then in QA do this:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Consult http://support.microsoft.com/default.aspx/kb/274750 for more info.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Buk Usu" <bukusu@.gmail.com> wrote in message
news:uXWsnAj8GHA.568@.TK2MSFTNGP05.phx.gbl...
>I have a box
> windows 2003 ent ed with 8GB or ram
> issue is its only seeing 4GB memory and not the 6 I set it at
> I set the instance to enable AWE
> what am I missing ? /3GB ? /PAE
> I want SQL Server to use 6gb and leave 2GB for windows and company
> Thanks
>
|||do i need /3gb ?
should i remove it ?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uxL4CTj8GHA.1188@.TK2MSFTNGP05.phx.gbl...
>I take it you are using SQL 2000 Enterprise Edition which can take
>advantage of the PAE switch.
> In your boot.ini file enable /PAE, and then in QA do this:
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> Consult http://support.microsoft.com/default.aspx/kb/274750 for more info.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Buk Usu" <bukusu@.gmail.com> wrote in message
> news:uXWsnAj8GHA.568@.TK2MSFTNGP05.phx.gbl...
>
|||remove it!
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Buk Usu" <bukusu@.gmail.com> wrote in message
news:eUkvy3k8GHA.3760@.TK2MSFTNGP02.phx.gbl...
> do i need /3gb ?
> should i remove it ?
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:uxL4CTj8GHA.1188@.TK2MSFTNGP05.phx.gbl...
>
|||Thanks Hillary
I ended up fixing the issue - but had to apply
http://www.microsoft.com/downloads/d...displaylang=en
Fix: Not All Memory is Available When AWE is Enabled on a Computer Running
32-bit Version of SQL Server 2000 SP4 (899761)
all looks ok now
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23YXmEPr8GHA.2288@.TK2MSFTNGP05.phx.gbl...
> remove it!
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Buk Usu" <bukusu@.gmail.com> wrote in message
> news:eUkvy3k8GHA.3760@.TK2MSFTNGP02.phx.gbl...
>
|||Hi All,
I need same/similar help but I am running Windows 2000 AS (sp4)
We have Windows 2000 Advanced Server sp4
SQL Server 2000 Enterprise Edition sp4 plus HOT Fix (KB899761)
Boot.ini filoe has /3GB switch
Total Memory Available = 8.0 GB
SQL Server configuration as follow:
min memory per query (KB) = 2048
max server memory (MB) = 5097
set working set size =0
awe enabled =1
The SQL Server service account seems to have all appropriate permisison
(lock memory etc.)
But it seems that SQL Server can only allocate approx 2.4 GB of memory
Any help would be greatly appreciated!
Kamal
"Buk Usu" wrote:

> Thanks Hillary
> I ended up fixing the issue - but had to apply
> http://www.microsoft.com/downloads/details.aspx?FamilyID=7C407047-3F1F-48B8-9E4C-DC32875E1961&displaylang=en
> Fix: Not All Memory is Available When AWE is Enabled on a Computer Running
> 32-bit Version of SQL Server 2000 SP4 (899761)
> all looks ok now
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23YXmEPr8GHA.2288@.TK2MSFTNGP05.phx.gbl...
>
>