Memory Management on cluster

I have an active/active two node cluster, each node runs Windows 2000
Advanced Server and SQL 2000 Enterprise Edition. Each node has 3.7 GB
of memory. The 3GB switch is enabled on both nodes.
When SQL Server on nodeA fails over to nodeB, will this instance only
have .7 GB of memory to use? Or can the two SQL instances share the 3
GB?<emnova@.gmail.com> wrote in message
news:1149780738.792282.241150@.j55g2000cwa.googlegroups.com...
>I have an active/active two node cluster, each node runs Windows 2000
> Advanced Server and SQL 2000 Enterprise Edition. Each node has 3.7 GB
> of memory. The 3GB switch is enabled on both nodes.
> When SQL Server on nodeA fails over to nodeB, will this instance only
> have .7 GB of memory to use? Or can the two SQL instances share the 3
> GB?
>
SQL Server will yield memory when the system is under memory pressrure.
However the process is slow, and will be painful in case of a failover. If
you really want to guarantee good performance on failover, you should add
memory or trim the max memory size of each virtual server.
David|||<emnova@.gmail.com> wrote in message
news:1149780738.792282.241150@.j55g2000cwa.googlegroups.com...
> I have an active/active two node cluster, each node runs Windows 2000
> Advanced Server and SQL 2000 Enterprise Edition. Each node has 3.7 GB
> of memory. The 3GB switch is enabled on both nodes.
> When SQL Server on nodeA fails over to nodeB, will this instance only
> have .7 GB of memory to use? Or can the two SQL instances share the 3
> GB?
They're share it (I'm assuming you don't have PAE enabled also, which you
shouldn't in this case.)
I'd probably test this though and see if I could limit say nodeB to 1.5 gig
and see what that does to performance.
Ideally, if you can, upgrade the RAM in both machines.

>