Multi insatnce cluster with AWE Enabled for one but two running with 2,6GB of RAM

  • Hello,

    We have a cluster made of 3 servers, 2 actives and one for majority node set. On one active node, there are three instances running. One is AWE enabled and the other not.

    The problem is that when we look in the task manager or select the total memory usage in perfmon, we see that there is one instance that is NOT AWE enabled that runs with 2,6GB of memory.

    This server is running Windows 2003, SQL Server 2000 Enterprise Edition with SP4, 8 CPU and 8 GB of memory, connected to the SAN.

    Is there someone that meets this problem or has one idea on the root cause of this behavior?

  • that's a flaw in taskmanager. (it cannot handle AWE stuff) There is more info on it at sqlservercentral.

    I think perfmon shows correct figures.

     

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • In fact, even in the master..sysperfinfo table, the value for the Total Server Memory is:

    2638 MB for the instance where AWE is not set (here is on sp_configure extract)

    name                     minimum     maximum     config_value   run_value

    awe enabled           0                1                  0                   0

    2647 MB for the instance where AWE is set

    name                     minimum     maximum     config_value  run_value

    awe enabled           0                 1                  1                 1

    Here after, the results from Perfmon in a CSV file:

    "(PDH-CSV 4.0) (Romance Standard Time)(-60)","\\SERVER1\MSSQL$INST1:Memory Manager\Total Server Memory (KB)","\\SERVER1\MSSQL$INST2:Memory Manager\Total Server Memory (KB)","\\SERVER1\MSSQL$INST3:Memory Manager\Total Server Memory (KB)"

    "03/12/2007 10:54:15.563","2701904","41216","2713048"

    "03/12/2007 10:54:30.562","2701904","41216","2712392"

    "03/12/2007 10:54:45.561","2701904","41216","2713024"

    "03/12/2007 10:55:00.561","2701904","41216","2713216"

    "03/12/2007 10:55:15.560","2701904","41216","2712952"

    "03/12/2007 10:55:30.560","2701904","41216","2712720"

    "03/12/2007 10:55:45.559","2701904","41216","2710168"

    "03/12/2007 10:56:00.559","2701904","41216","2709528"

    "03/12/2007 10:56:15.558","2701904","41216","2710248"

    As you can see, the memory used is greater than 1.8GB for one instance without AWE enabled.

  • That should be no problem ...

    http://www.sql-server-performance.com/awe_memory.asp

    EE can use up to 3Gb without awe

     

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • the correct memory usage is reported in sysperfinfo.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • sounds like you have the 3gb switch enabled in boot.ini

    I'm not sure I totally follow your setup, sorry, you have three nodes, is there one instance on each ? I'd say you need to do some memory config, the total of memory allocated to all instances which can run on a single node should not exceed the total memory availsble for sql server. so with 8gb on each node I'd say you logically have 6gb , maybe 6.5gb  available for sql server, that should be allocated to the instances that can run on a node, so if all three can run on a node then the max memory for each node should be just over 2gb ram , iff divided equally. If it's two instances to a node then allocate 3gb. You can't use multiple instances without allocating fixed memory and especially on a cluster.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • Exactly,

    /3GB is enabled and for this case, the instance with AWE enabled use the PAE memory, meanwhile the instances without awe enabled could use from 0 to 3GB in the "Normal" memory.

    Many thanks for your help.

    Regards,

    Regis Marchal

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply