Re: AWE - SQL Server 2000 - Memory usage

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

  • Re: MDAC, SQL Server, MSXML w/SDK, .NET FRAMEWORK 1.1 on XP Home?
    ... "Roger Abell" wrote: ... rather than the full SQL Server. ... > Evidently the install method you are using is not providing ... > installed and/or that I am the System Administrator. ...
    (microsoft.public.windowsxp.security_admin)
  • Re: SQL service manager
    ... It's an informational message - you can ignore it. ... for SQL Server in Enterprise Manager. ... RECONFIGURE statement to install. ...
    (microsoft.public.sqlserver.connect)
  • Virus blocking fix on XP....
    ... I can not install ... I get a message "The system Administrator has set policies to prevent this installation". ... bad segment on the hard drive which must have contained the boot info. ... McAfee has been scanning since Thursday evening and it still scanning ...
    (microsoft.public.windowsxp.general)
  • Virus blocking fix?
    ... I can not install ... I get a message "The system Administrator has set policies to prevent this installation". ... bad segment on the hard drive which must have contained the boot info. ... McAfee has been scanning since Thursday evening and it still scanning ...
    (alt.comp.anti-virus)
  • Re: Virus blocking fix on XP....
    ... I can not install ... I get a message "The system Administrator has set policies to prevent this installation". ... bad segment on the hard drive which must have contained the boot info. ... McAfee has been scanning since Thursday evening and it still scanning ...
    (microsoft.public.windowsxp.general)