February 23, 2004 at 10:00 am
Does anyone have any information on running multiple instances of SQL2000 on alternate nodes of a cluster.
I want to run 2 instances on one node and 2 different instances on the other node. If one of the nodes fails all 4 instances will run from the remaining node.
Is there any templates or white papers on this ??
Anyone experienced in doing this or attempting this ????
Thanks in advance.
February 23, 2004 at 11:49 am
You have to make sure the sum of the max server memory values for all the instances is less than the amount of physical memory in the computer.
Each instance needs their own disk and network resources.
You may experience slow performance if all instances fail over to run in one node and you really have to test that.
To install clustered SQL Server, see BOL at "Creating a Failover Cluster".
February 23, 2004 at 12:48 pm
That makes perfect sense thanks
...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply