Cluster Active-Active - Parallelism

Cluster active-active enviroment.
Memory: How can I determine how much memory I need to set ? If I leave
dynamically and one node falls down I receive message error about allocate
memory.
CPU: Processor - Parallelism - Use all available processors. There are 2
processors on each server. In this case I can set this option ON ? If the one
node falls down SQLserver will try to use 2 or 4 processors ?
thanks in advanceset max server memory on both servers so that fail over of either server does
not result in total memory greater than total server memory on each box.
Also with cpu if you have configured to use all available cpus then all
available cpus will be utilized. ie. sql will use only the number of
processors on the server.
HTH
"Shima" wrote:
> Cluster active-active enviroment.
> Memory: How can I determine how much memory I need to set ? If I leave
> dynamically and one node falls down I receive message error about allocate
> memory.
> CPU: Processor - Parallelism - Use all available processors. There are 2
> processors on each server. In this case I can set this option ON ? If the one
> node falls down SQLserver will try to use 2 or 4 processors ?
> thanks in advance
>|||It is useful that resurces used by instances, does not be greater than one
node...
I
"Olu Adedeji" wrote:
> set max server memory on both servers so that fail over of either server does
> not result in total memory greater than total server memory on each box.
> Also with cpu if you have configured to use all available cpus then all
> available cpus will be utilized. ie. sql will use only the number of
> processors on the server.
>
> HTH
>
> "Shima" wrote:
> > Cluster active-active enviroment.
> > Memory: How can I determine how much memory I need to set ? If I leave
> > dynamically and one node falls down I receive message error about allocate
> > memory.
> > CPU: Processor - Parallelism - Use all available processors. There are 2
> > processors on each server. In this case I can set this option ON ? If the one
> > node falls down SQLserver will try to use 2 or 4 processors ?
> > thanks in advance
> >