After having quite some research, I found out that Active/Active servers are
not recommended by most of people as clustering is mainly is a failover
technology. However, there was an opinion of using Clustering for load
balance in a single instance SQL 2005 database. Based on ...

I have a n+1 cluster running Windows 2003 sp2 64-bit and Sql 2005 64bit.  
When I use perfmon all the counters for the instances that are not running on
the active node return a value 0.  For example if Node A has Sql instance A
and Node B has Sql insatnce B, when I run perform on ...

I have a SQL 2005 cluster as the backend of my OCS 2007 environment. It is a
shared server. I recently found information that the OCS DB should be on its
own SQL server, or at least its own instance with dedicated spindles for the
data and log files.

I have 2 nodes Windows Server 2003 R2 Enterprise x64 Edition with Service
Pack 2.
I need to install SQL2005 Standard Edition with multiples instances.
Each instance has its own one Cluster Group.

so although I have read a few things in both directions, it seems I need the
MSDTC for a SQL cluster. When I create it I have to assign dependencies to a
drive and name.
By default, when a cluster is built there is "group 0" which is my share

Did I need to apply SOL1 2005 SP1 on all notes or just Note1?

On a failover cluster, how does does windows redirect the traffic to
correct physical machine when the clients connect to the virtual
network name.
Regards

I am running sql 2005 sp2 64 bit on a windows server 2003 64 bit cluster.
This has been working in an active/active configuration. I had a problem
though where one of the instances wouldnt startup. I resolved this by
setting the port in the registry and then running the cluster ...

Before installing SQL2005 EE, does IIS need to be installed on all nodes, or
just on the first node? Thanks.

I've got a 2-node SQL Server 2005 running. There is no sql service packs
installed and Windows 2003 service packs. the sql-cluster was built
while back.  Is there a special way to install SQL SP2? Do I just install
the SP2 on each node?

SQL 2k5 on Win 2k3, all fully patched. CLustering is enabled and working, but
when I attempt to log on to the CSA app, I cannot change to the virtual
server name, when I enter the name (FQDN, simple name) i get the error:
Computer xxxx does not exist on the network, or the ...

We have mix of both SQL 2000 and 2005 enviroments. The push is to consolidate.
On 4 node windows 2003 64 bit cluster: Is it possible to host on 2 nodes -
SQL 2000 A/A Virtual server and on 3rd and 4th node SQL 2005 A/A vuirtual
server?

so i've built up my w2k3 ent 64bit cluster with no problems... its all happy
and working well... created the DTC resource and went to install SQL.. it
goes well until it asks what group to put it in and what disk to use for the
data files.

Maybe a really easy question this one, but is there an easy way to
find out which domain groups the services have been setup under in an
existing clustering installation.
I have been looking around for a while now to see if this is possible.

I am new both for cluster and SQL, and I have built a new two nodes SQL
cluster. For testing failover, I am planing to write a long sql script and
have a client excute and write data in. During the writing, I am going to
take off network or power from node 1. can I expect the ...