 Re: Memory in a 2 node Active/Active cluster -
11-21-2008
, 08:20 AM
You will see bad performance during a failover with max memory at 50GB. If
the memory needs are equal, then going with 30GB or less for each would be a
better approach. Keep in mind that you may have to reduce it further,
especially if you have a high number of CPU cores. The OS still has to run
and 64-bit OS's like RAM.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Russ" <Russ (AT) discussions (DOT) microsoft.com> wrote
Hi,
I have a scenario involving a two node cluster each running a SQL 2005 (x64)
instance. Each node has 64GB of RAM and 'lock pages in memory' is set.
If I configure, via 'Max Server Memory', each node to use say 50GB of RAM -
what happens during a failover. I'm guessing that because of the 'lock pages
in memory' the surviving instance will not release any memory to accomodate
the failed instance and will be forced to compete for the remaining 14 GB of
RAM with the OS.
Whats the best practice here? Should I configure each node to use only 30GB
of RAM? (leaving 4GB for the OS).
Thanks for any advice....
 |
Linear Mode
