Re: Please advise cluster configuration

Here, here to Edwin's recommendations.

Moreover, you did not say if this installation was x86 or IA-64.

If the former, you will need to set AWE enabled for the BPool to be able to
address more than 4 GB and you will want to limit each node to only 1/2 (or
slightly less) than available memory.

If the latter, and you are not running with Lock Pages in Memory, then you
could specify the full memory amount on each node, but you might want to
also specify a minimum memory amount as well. The Itanium build is more
aggressive about acquiring the minimum memory setting and will cause the
other instance to give up excess memory more readily.

The reason is that in a multi-instanced configuration, there will be times
when you will need or have to have multiple instances running on a single
node, and you will need available resources for each.

Sincerely,


Anthony Thomas


--

"Edwin vMierlo" <EdwinvMierlo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:eyyfUfiNHHA.4720@xxxxxxxxxxxxxxxxxxxxxxx
Best practice is that you keep the Hardware configuration of all your
cluster nodes the same.
Assuming that you already have the /PAE switch in your boot.ini file, I
would recommend that you add 4GB ram to the node with only 8GB ram.


"DKRReddy" <dkrreddy@xxxxxxxxxxx> wrote in message
news:%23UPSxwbNHHA.4152@xxxxxxxxxxxxxxxxxxxxxxx
We have datawarehouse servwer with Active/Active cluster.
One node has 8GB Ram and another node has 12GB.
Right now I have configured for both the nodes the Max.Sql Server Memory
to
be 8GB.

Both the nodes are running with windows 2003 SP1and SQL Server 2000 SP4
with
the 8 CPU.

Please advise the best configuration for this.

Thanks.






.

Relevant Pages

  • Re: Alocated Memory Error (SQLSERVR)
    ... memory for the process dropped from 990 to 330. ... to grab available RAM for performance reasons, ... configured alert threshold rather than an error in MSDE configuration. ... Server 2000 SP4, ...
    (microsoft.public.windows.server.sbs)
  • Re: Asus P4P800-X RAM Configuration Help
    ... I'm trying to my friend overseas work out a RAM configuration on this board. ... We are going to do a clean install of XP and I would like to figure out the best RAM configuration to eliminate this constant paging. ... the memory angle first, may be ignoring some other problem with that system. ... Placing 4 x 256MB makes sense, if all the DIMMs have the same number ...
    (alt.comp.periphs.mainboard.asus)
  • Re: Alocated Memory Error (SQLSERVR)
    ... I had the same problem except, my memory hog was SBSMONITORING. ... critical and you don't want it grabbing all that RAM. ... configured alert threshold rather than an error in MSDE configuration. ... Server 2000 SP4, ...
    (microsoft.public.windows.server.sbs)
  • Re: A large amount of memory is committed to applications and proc
    ... SBSMONITORING using a max of 852MB of RAM, so I ran the limiting again, ... the INETINFO.EXE process is allocating more memory than usual....etc. ... I have checked the configuration for the Allocated Memory Alert and it ...
    (microsoft.public.windows.server.sbs)
  • Re: Alocated Memory Error (SQLSERVR)
    ... I had the same problem except, my memory hog was SBSMONITORING. ... to grab available RAM for performance reasons, ... configured alert threshold rather than an error in MSDE configuration. ... Server 2000 SP4, ...
    (microsoft.public.windows.server.sbs)