March 6, 2007 at 8:06 am
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?
March 6, 2007 at 10:21 am
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
March 12, 2007 at 4:01 am
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.
March 12, 2007 at 6:29 am
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
March 12, 2007 at 7:04 am
the correct memory usage is reported in sysperfinfo.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
March 12, 2007 at 7:09 am
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/
March 12, 2007 at 8:10 am
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