Re: AWE - SQL Server 2000 - Memory usage

Unless you have more than 4GB of physical RAM, and have /PAE in the boot.ini
file, AWE enabled has no effect. Clear /PAE in the boot.ini, set the /3GB
switch in boot.ini. Clear AWE enabled and set Max server memory to ~3GB.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Floris van Haaster" <floris@xxxxxxxxxxxxxxxxxxx> wrote in message
news:435e43af$0$11071$e4fe514c@xxxxxxxxxxxxxxxxx
> Haha :)
>
> Thanks for the tip!
>
> Now I see a total server memory of 1963704 kb..... but i enabled awe... so
> it should use more?
>
> --------------------------------
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> Configuration option 'awe enabled' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> Configuration option 'max server memory (MB)' changed from 3000 to 3200.
> Run the RECONFIGURE statement to install.
> --------------------------------
>
> Best regards
>
> Floris
>
>
> "Geoff N. Hiten" <sqlcraftsman@xxxxxxxxx> schreef in bericht
> news:uZNjcsW2FHA.1420@xxxxxxxxxxxxxxxxxxxxxxx
>>I probably shouldn't post before my morning caffeine. :) I thought I
>>remembered a section in that article describing the Task Manager
>>limitation. Evidently I mis-remembered.
>>
>> The counter you are looking for is SQLServer:Memory Manager | Total
>> Server Memory(KB).
>>
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>> "Floris van Haaster" <floris@xxxxxxxxxxxxxxxxxxx> wrote in message
>> news:435e32c3$0$11061$e4fe514c@xxxxxxxxxxxxxxxxx
>>> Uhhh maybe you should read my post first before you send a reply?
>>> The exact same url is in my post......
>>>
>>> And the question is not how i configure it because i already did....
>>>
>>> From other newsgroups:
>>>
>>> -------------------------------------------------------------------------------------------------------------------------------------
>>> OTHER USER:
>>> Task Manager isn't AWE aware. Use Perf Mon instead.
>>>
>>> ME:
>>> But what meter shows the correct value?
>>>
>>> When i take a look @ "SQLServer:Memory Manager > Maximum
>>> Workspace memory
>>> (KB)" it's value = 1175344 KB and that's only 1 GB or so...
>>>
>>> Or do i have to look at another counter?
>>> -------------------------------------------------------------------------------------------------------------------------------------
>>>
>>> Best regards
>>>
>>> Floris
>>>
>>>
>>> "Geoff N. Hiten" <sqlcraftsman@xxxxxxxxx> schreef in bericht
>>> news:uC%23pOQW2FHA.892@xxxxxxxxxxxxxxxxxxxxxxx
>>>> How to configure memory for more than 2 GB in SQL Server
>>>> http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech
>>>>
>>>> --
>>>> Geoff N. Hiten
>>>> Senior Database Administrator
>>>> Microsoft SQL Server MVP
>>>>
>>>> "Floris van Haaster" <floris@xxxxxxxxxxxxxxxxxxx> wrote in message
>>>> news:435deada$0$11066$e4fe514c@xxxxxxxxxxxxxxxxx
>>>>> Hi all!
>>>>>
>>>>> We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in
>>>>> it.
>>>>> Microsoft gave the advise to enable the "AWE" sql server option and
>>>>> the
>>>>> "/3GB" windows option.
>>>>>
>>>>> (http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech)
>>>>>
>>>>> But when I go to the task manager I see SQL server is only using about
>>>>> 144
>>>>> mb ?
>>>>> And the total system memory usage is 2.6 GB.... and i cannot see the
>>>>> process
>>>>> that is using that amount of memory......
>>>>>
>>>>> -How can I see what it using so much memory?
>>>>> -Is this a normal situation when you enablee /3GB and AWE or do you
>>>>> see
>>>>> sqlserver.exe consuming more memory in your task manager?
>>>>>
>>>>> I want to know if there is something wrong with our configuration.
>>>>>
>>>>> Thanks in advance for your answer!
>>>>>
>>>>> Best regards
>>>>>
>>>>> Floris van Haaster
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


.

Relevant Pages
Loading