I have installed SQL2000 and SQL2005 on the same computer accessing the same
DB
When run the following simple queries the performance is as follows
Could some one please advice on how improve the performance on these queries

I have built a 2005 two node sql cluster and we are seeing very poor client
access speeds. Clearly there could be a zillion reasons for this and I am
trying to narrow them down.
My question is about location of the MSDTC. I currently have the MSDTC

I had a cluster named oldcluster. I created a new cluster called newcluster.
I evicted node1 from oldcluster, ran "cluster node node1 /forcecleanup. I
changed the dns entry for oldcluster to point to the newcluster ip. Then
added node1 to newcluster.

I need a simple procedure to upgrade our SQL2005 active/active cluster. It's
presently unpatched. From what I understand I need to do the following :
  1- Failover node 2  ressources to node 1
  2- Log on node 1 and install the SP2 on the two instances

I have a cluster with 3 nodes, under SYSTEM in the event
viewer I receive those Warning message every 3 secondes.  
ID 1123:The node lost communication with cluster
node 'NODE1' on network 'PublicA'.

SQL Server 2000 and 2005 Cluster coexisting...?, MS say yes but I wonder if
it is a good idea in an production environment...
Someone has experience in this configuration?
thanks in advance...

I am running a SQL Server 2000 in an active/passive cluster. I want to
move all SQL Server structures (BACKUP, Data, FTDATA, JOBS, LOG,
REPLDATA ) to a new location. Can all of them be moved or do some have
to stay on the local drive? I know how to move all the databases and

I have setup Active/Passive in the past with no problems
With Active/Active/Passive are all nodes on the same heartbeat?
Is the correct Private IP configuration correct?
Node1 10.0.0.1

All:
I have a 6 yr old SQL2000 server running on Win2000.  I have two brand
new HP DL380G5 servers that were ditched from another project which
have six 72 GB HDD's - two mirrored for the OS, and four RAID5'd for

I can run the SQL 2005 Upgrade Advisor against stand alone SQL 2000
Servers and get results but when I ran it against our SQL 2000 Cluster
it does not find the SQL Server componets.  It does see the Analysis
Services and the Data Transformation Services .  I've tried connecting

I can run the SQL 2005 Upgrade Advisor against stand alone SQL 2000
Servers and get results but when I ran it against our SQL 2000 Cluster
it does not find the SQL Server componets.  It does see the Analysis
Services and the Data Transformation Services .  I've tried connecting

Hello Gurus
I have win2k3 cluster (RTM) no sp on os with SQL2000 sp4 running.
MSDTC is not configured on the cluster.
THe plan is to install MSDTC as a cluster resource in the cluster group

PLEEEEEASE  HELP
I am at my wits end now 3 days 5-6 Install / Un-Installs with trying
to get this 2 node Active/Passive to start the SQL Server Agent.
The Cluster Resource Registry entries are just like MS MSDN, Technet

Is there a limit on how many nodes you have within a SQL 2000 enterprise
cluster hosted on a Windows 2003 Enterprise cluster?
The reason I ask is because of the following Support KB article.
http://support.microsoft.com/kb/811054

We have a 2-node Server 2003 SP1 cluster with SQL 2005 SP1.  We had a series
of power outages, and, the "B" node was damaged and won't run the cluster
service.  In addition, it looks like the \BIN file under SQL is missing, so,
SQL won't start on that node, either.  A node is ...