I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB
of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL
Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory
Manager/Total Server Memory). I would like to allocate nearly all of
the available memory on the machine to SQL Server.
I seem to have the same symptons described in this MS article-
http://support.microsoft.com/default.aspx?kbid=899761, but I get a "No
Qualifying Products" error when I try to install the HOTFIX.
Any help would be greatly appreciated.
NickHi
appologies if this is an obvious response - are you using std or ent?
the hotfix is for ent and dev editions.
nicholasbecker@.gmail.com wrote:
> I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB
> of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL
> Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory
> Manager/Total Server Memory). I would like to allocate nearly all of
> the available memory on the machine to SQL Server.
> I seem to have the same symptons described in this MS article-
> http://support.microsoft.com/default.aspx?kbid=899761, but I get a "No
> Qualifying Products" error when I try to install the HOTFIX.
>
> Any help would be greatly appreciated.
>
> Nick
>|||Look here on the UPDATE section
http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
Have you applied this hotfix?
Ben Nevarez, MCDBA, OCP
Database Administrator
"nicholasbecker@.gmail.com" wrote:
> I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB
> of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL
> Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory
> Manager/Total Server Memory). I would like to allocate nearly all of
> the available memory on the machine to SQL Server.
> I seem to have the same symptons described in this MS article-
> http://support.microsoft.com/default.aspx?kbid=899761, but I get a "No
> Qualifying Products" error when I try to install the HOTFIX.
>
> Any help would be greatly appreciated.
>
> Nick
>|||I'm using Enterprise editiion (req's for a cluster).
The link seems to refer to SQL Server SP4. We are have installed sp4
if that's the hotfix you're referring to.
Nick
Showing posts with label pae. Show all posts
Showing posts with label pae. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
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...
>
>
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...
>
>
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
ThanksI 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/...&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/...&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...
>
>
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
ThanksI 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/...&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/...&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...
>
>
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
ThanksI 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...
>>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
>|||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...
>>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
>>
>|||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...
> 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...
>>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
>>
>>
>
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
ThanksI 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...
>>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
>|||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...
>>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
>>
>|||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...
> 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...
>>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
>>
>>
>
memory - PAE / AWE...........
My server is a mssql2000 sp3 server in windows 2000
advanced server.
My server has 3 GB of memory. PAE is enables in the
boot.ini. My memory to mssql is unrestricted. In the task
manager, the memory of mssql shows as 2.7GB. I still have
page faults at 9,27,6683 for 21 days of non-reboot.
Is MSSQL really using 2.7 GB? DO I need more memory?
What is the 'awe enabled' option all about?
regards,
bharathIf you have only 3 GB then the only switch you need in boot.ini is /3GB, you
don't need /PAE. Assuming you have SQL2000 Enterprise Edition then SQL
Server will be able to use the memory. You don't need to enable awe when you
only have 3GB of RAM.Which counter are you using to determine page faults ?
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"bharath" <anonymous@.discussions.microsoft.com> wrote in message
news:0a1701c3d5b6$f9aec310$a101280a@.phx.gbl...
> My server is a mssql2000 sp3 server in windows 2000
> advanced server.
> My server has 3 GB of memory. PAE is enables in the
> boot.ini. My memory to mssql is unrestricted. In the task
> manager, the memory of mssql shows as 2.7GB. I still have
> page faults at 9,27,6683 for 21 days of non-reboot.
> Is MSSQL really using 2.7 GB? DO I need more memory?
> What is the 'awe enabled' option all about?
> regards,
> bharath
advanced server.
My server has 3 GB of memory. PAE is enables in the
boot.ini. My memory to mssql is unrestricted. In the task
manager, the memory of mssql shows as 2.7GB. I still have
page faults at 9,27,6683 for 21 days of non-reboot.
Is MSSQL really using 2.7 GB? DO I need more memory?
What is the 'awe enabled' option all about?
regards,
bharathIf you have only 3 GB then the only switch you need in boot.ini is /3GB, you
don't need /PAE. Assuming you have SQL2000 Enterprise Edition then SQL
Server will be able to use the memory. You don't need to enable awe when you
only have 3GB of RAM.Which counter are you using to determine page faults ?
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"bharath" <anonymous@.discussions.microsoft.com> wrote in message
news:0a1701c3d5b6$f9aec310$a101280a@.phx.gbl...
> My server is a mssql2000 sp3 server in windows 2000
> advanced server.
> My server has 3 GB of memory. PAE is enables in the
> boot.ini. My memory to mssql is unrestricted. In the task
> manager, the memory of mssql shows as 2.7GB. I still have
> page faults at 9,27,6683 for 21 days of non-reboot.
> Is MSSQL really using 2.7 GB? DO I need more memory?
> What is the 'awe enabled' option all about?
> regards,
> bharath
Subscribe to:
Posts (Atom)