Multiple instances in SQL Cluster

Hi All,
I have joined a company recently. They are having mutiple servers of SQL
Server 2000. And one of them is a two node SQL server cluster. It is having
a Active/Active configuration. That means on one node we have one instance
and other have the second instance with failover on to each other. I am
planning to install a third instance on that cluster.
But I am totally confused at online help that says, I cannot have more than
one instance per server in a cluster, at the same time it says -we can have
upto 16 servers in cluster. What does it mean? Can't I have more than two
instances with two nodes?
Thanks a lot,
VMyou can have up to 16 instances installed but even by adding the 3rd you
have to be careful that if a node fails the the remaining Node has enough
memory to run all instances. See Memory Configuration section below
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
cheers,
Andy.
"VM" <VM@.discussions.microsoft.com> wrote in message
news:AAC5F30B-B27B-489E-9311-DD9E18F169D0@.microsoft.com...
> Hi All,
> I have joined a company recently. They are having mutiple servers of SQL
> Server 2000. And one of them is a two node SQL server cluster. It is
> having
> a Active/Active configuration. That means on one node we have one
> instance
> and other have the second instance with failover on to each other. I am
> planning to install a third instance on that cluster.
> But I am totally confused at online help that says, I cannot have more
> than
> one instance per server in a cluster, at the same time it says -we can
> have
> upto 16 servers in cluster. What does it mean? Can't I have more than
> two
> instances with two nodes?
> Thanks a lot,
> VM|||> But I am totally confused at online help that says, I cannot have more than
> one instance per server in a cluster, at the same time it says -we can have
> upto 16 servers in cluster. What does it mean? Can't I have more than two
That means you can have one SQL instance per virtual server in a cluster,
and a cluster cna have multiple virtual servers. A virtual server in this
context refers to an IP address and its related network name, and after you
have installed the SQL instance, that IP and network name will be what you
use to connect to the SQL instance. If you examine the cluster using Cluster
Administrator, each virtual server is wrapped up in a resource group. It's
okay to have multiple IPs and network names for the same virtual server. In a
cluster, you can have multiple virtual servers in their separate groups. For
SQL2000, Microsoft supports up to 16 such cluster resource groups (i.e. 16
SQL virtual servers), each of which supports a separate SQL instance.
In theory, each cluster virtual server could support multiple SQL instances
by identifying the SQL instances with different ports. But that is not how
SQL2000 is actually implemented by Microsoft in a Windows cluster.
Linchi
"VM" wrote:
> Hi All,
> I have joined a company recently. They are having mutiple servers of SQL
> Server 2000. And one of them is a two node SQL server cluster. It is having
> a Active/Active configuration. That means on one node we have one instance
> and other have the second instance with failover on to each other. I am
> planning to install a third instance on that cluster.
> But I am totally confused at online help that says, I cannot have more than
> one instance per server in a cluster, at the same time it says -we can have
> upto 16 servers in cluster. What does it mean? Can't I have more than two
> instances with two nodes?
> Thanks a lot,
> VM|||Linchi and Andy,
Thankyou so much for your replies. Not it makes more sense to me.
Warm regards,
VM
"Linchi Shea" wrote:
> > But I am totally confused at online help that says, I cannot have more than
> > one instance per server in a cluster, at the same time it says -we can have
> > upto 16 servers in cluster. What does it mean? Can't I have more than two
> That means you can have one SQL instance per virtual server in a cluster,
> and a cluster cna have multiple virtual servers. A virtual server in this
> context refers to an IP address and its related network name, and after you
> have installed the SQL instance, that IP and network name will be what you
> use to connect to the SQL instance. If you examine the cluster using Cluster
> Administrator, each virtual server is wrapped up in a resource group. It's
> okay to have multiple IPs and network names for the same virtual server. In a
> cluster, you can have multiple virtual servers in their separate groups. For
> SQL2000, Microsoft supports up to 16 such cluster resource groups (i.e. 16
> SQL virtual servers), each of which supports a separate SQL instance.
> In theory, each cluster virtual server could support multiple SQL instances
> by identifying the SQL instances with different ports. But that is not how
> SQL2000 is actually implemented by Microsoft in a Windows cluster.
> Linchi
> "VM" wrote:
> > Hi All,
> >
> > I have joined a company recently. They are having mutiple servers of SQL
> > Server 2000. And one of them is a two node SQL server cluster. It is having
> > a Active/Active configuration. That means on one node we have one instance
> > and other have the second instance with failover on to each other. I am
> > planning to install a third instance on that cluster.
> >
> > But I am totally confused at online help that says, I cannot have more than
> > one instance per server in a cluster, at the same time it says -we can have
> > upto 16 servers in cluster. What does it mean? Can't I have more than two
> > instances with two nodes?
> >
> > Thanks a lot,
> > VMsql