boot.ini /3GB problem

Hello,
I have win 2k3 standard edition, 4 GB of memory, SQL 2000 enterprise
edition. I have tryed to get more than 2 GB for sql. I have tryed /3GB swich
with awe enabled on sql 2000 without any good result. I could said even
situation is wors because now sql allocate maximum 1,327 GB.
Does anyone hnow what can be wrong '
I have read many of support pages from MS for allocate more than 2G and
nothing is working :(
regards
Pawel MylkaHi
Task manager is not the correct tool to evaluate if memory over 2 GB is
being used as it is not capable of it.
Use Windows Performance Monitor (%SystemRoot%\system32\perfmon.msc /s) to
see how much "Target Server Memory" is. It should be close to 2700 when SQL
Server is configured correctly.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pawel Mylka" <pawel.mylka@.itcontrol.pl> wrote in message
news:eEnOZij4FHA.252@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have win 2k3 standard edition, 4 GB of memory, SQL 2000 enterprise
> edition. I have tryed to get more than 2 GB for sql. I have tryed /3GB
> swich
> with awe enabled on sql 2000 without any good result. I could said even
> situation is wors because now sql allocate maximum 1,327 GB.
> Does anyone hnow what can be wrong '
> I have read many of support pages from MS for allocate more than 2G and
> nothing is working :(
> regards
> Pawel Mylka
>|||Hi,
As Mike pointed out use Performance monitor to view the memory usage. As
well as make the memory static (set min and max meory)
once you enable AWE to SQL Server.
Thanks
Hari
SQL Server MVP
"Pawel Mylka" <pawel.mylka@.itcontrol.pl> wrote in message
news:eEnOZij4FHA.252@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have win 2k3 standard edition, 4 GB of memory, SQL 2000 enterprise
> edition. I have tryed to get more than 2 GB for sql. I have tryed /3GB
> swich
> with awe enabled on sql 2000 without any good result. I could said even
> situation is wors because now sql allocate maximum 1,327 GB.
> Does anyone hnow what can be wrong '
> I have read many of support pages from MS for allocate more than 2G and
> nothing is working :(
> regards
> Pawel Mylka
>|||Don't enable AWE unless you intend to go beyond 3GB.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OoI%23Nzt4FHA.3876@.TK2MSFTNGP09.phx.gbl...
> Hi,
> As Mike pointed out use Performance monitor to view the memory usage. As
> well as make the memory static (set min and max meory)
> once you enable AWE to SQL Server.
> Thanks
> Hari
> SQL Server MVP
> "Pawel Mylka" <pawel.mylka@.itcontrol.pl> wrote in message
> news:eEnOZij4FHA.252@.TK2MSFTNGP15.phx.gbl...
>> Hello,
>> I have win 2k3 standard edition, 4 GB of memory, SQL 2000 enterprise
>> edition. I have tryed to get more than 2 GB for sql. I have tryed /3GB
>> swich
>> with awe enabled on sql 2000 without any good result. I could said even
>> situation is wors because now sql allocate maximum 1,327 GB.
>> Does anyone hnow what can be wrong '
>> I have read many of support pages from MS for allocate more than 2G and
>> nothing is working :(
>> regards
>> Pawel Mylka
>>
>