How better setup memory usage on Active-Active cluster for
SQL servers?
Both physical servers have 8GB memory and 8CPU. I'm using
Win2K Adv. Serv. SP4 and SQL2K Enterprise Server.
in boot.ini using keys: /3GB /PAE, I'm just in the process
of setup and I'm going to use AWE, but I understand that
in this case server is not using memory dynamically and if
I will setup 7GB (1GB for Windows) usage and one of the
physical server will go down, then on the second physical
server I don't have any memory for first SQL server,
because second SQL server using all available 7GB (1GB for
Windows).
Also what about CPU - or with CPU everything fine if I
will setup all 8cpu to use by SQL server on both servers?

PS: This servers are dedicated to SQL.

Alex.

The two instances will content for CPU but will balance out fairly well.
You must statically allocate memory so that all virtual servers have enough
resources to run on the same box at the same time. 7GB+7GB +OS overhead =
not good if you have to failover with only 8GB on each host node. Typically
for this setup I leave about 1GB for the OS and allocate the rest for SQL.
How you divide the memory really depends on your particular setup.

--
Geoff N. Hiten
Senior Database Administrator
Careerbuilder.com




"Alex Rybalov" <alex (AT) covers (DOT) com> wrote