I have a two-node SQL2k active/passive failover cluster
on WIN2k ADV SP3.

I would like to install a new instance of SQL2k for
another application in the failover cluster.
Please advice.

Help appreciated

Hello, Olutimi!
You wrote on Wed, 18 Feb 2004 03:13:37 -0800:

O> I have a two-node SQL2k active/passive failover cluster
O> on WIN2k ADV SP3.

O> I would like to install a new instance of SQL2k for
O> another application in the failover cluster.
O> Please advice.

Exactly in which are you need advices ?

You can setup the new instance by simply using SQL Server
setup, the new instance can then be assigned to either
nodes.

Be sure to evaluate rigorously how memory and CPU resources
will be split among the two instances otherwise when a node
fails, and both instances are running on the same machine,
service availability may be discontinuous due to resource
drainage.

HTH
--
Gianluca Hotz - SQL Server MVP
http://italy.mvps.org - http://www.ghotz.com
http://www.ugiss.org - http://www.ugidotnet.org

Thanks for the help.
The question I like to ask is Can I have another Virtual
Server on the existing Virtual Server (MS SQL 2000
Cluster)?.
My intention is to have another instance in another
virtual Server. If this is practicable what are the
downside.


Thanks for your kind help.

Hello, Olutimi!
You wrote on Thu, 19 Feb 2004 02:34:01 -0800:

O> Thanks for the help.
O> The question I like to ask is Can I have another Virtual
O> Server on the existing Virtual Server (MS SQL 2000
O> Cluster)?.

Yes, it is not another virtual server on the existing
virtual server though, it's a new and separate virtual
server that can be run on any of the two nodes (this
meaning that serveral virtual server can run simultaneously
on the same node).

Each virtual server will have a separate set of cluster
resources (IP addresses, network names, disks, SQL Server
services, SQL Server Agent services).

O> My intention is to have another instance in another
O> virtual Server. If this is practicable what are the
O> downside.

Yes it is practical, but you will have to asses carefully
how resources will be used among the two instances.

For example: suppose you have 4GB of RAM on each node
and you have instance VS1\SQLI1 on node A configured
to use all available memory and instance VS2\SQLI2 on
node B configured to use all available memory.

During regular operations both instances works fine,
if one of the two nodes dies, let's say node A, the
other node, B in our example, starts up the instance
failed from node A, and since they are both configured
to use all available memory, you have a problem.

You may want to have a look at this chapter of
the SQL Server 2000 Resource Kit that explains
all this problems:

http://www.microsoft.com/technet/pro...art4/c1261.asp

HTH
--
Gianluca Hotz - SQL Server MVP
http://italy.mvps.org - http://www.ghotz.com
http://www.ugiss.org - http://www.ugidotnet.org

Gianluca is correct.

Regards,
Shirley
SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.