Please advise cluster configuration

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: Suns Niagara is out
    ... >> The configuration in the SAP benchmark is at least $27K on the web site. ... >that you referred to above costs about that with almost no RAM: ... >cost below). ... >supply, power distribution... ...
    (comp.arch)
  • Re: release 6.1
    ... tell me the minimum configuration it should be.. ... In fact you could take a computer with only half the RAM of the above, ... the disk space, and half the CPU speed, and still not have a problem running ... just needs a little patience. ...
    (freebsd-questions)
  • Re: OT: Chip configuration issue of RAM
    ... Jorge Cervantes wrote: ... I want to add 1 GB memory to the existing memory. ... The only problem is the difference in chip configuration: 128 x 64 vs. 128 x 72. ... It is absolutely essential that any new RAM modulebe fully compatible with both the motherboard and/or any other RAM modulealready in the system. ...
    (microsoft.public.windowsxp.newusers)
  • Re: A large amount of memory ... UPDATE
    ... Ever since I limited the SBSMONITORING RAM usage, ... 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)