We have some sp transactions that take minutes to process and tend hog the
cpu resources slowing other requests on a busy website.  I have a few
questions.
1. Can a specific cost be assinged to a stored procedure, so as to allow for

I have a question, we have 2 node cluster Win2003 R2 Enterprise with SP2 ,
SQL Server virtual is installed on cluster. It is SQL2005 Enterprise x64 with
SP2.
MSDTC resource is created as cluster resource in cluster group on node1 and

I am in the process of implementing a SQL Server 2005 Database Cluster and
have a question regarding the Quorum drive.
Proposed Specs:
2 - Dell NX1950 "XEON Quad Core" mated to Dell MD3000 setup as such...

Pardon if this is not the correct forum but I have a requirement to install
the Oracle client on a 2-node MS cluster used exclusively for SQL Server
2000 clustered instances. An application requires connectivity to external
Oracle datasources. Is it technically feasible create ...

Pardon if this is not the correct forum but I have a requirement to install
the Oracle client on a 2-node MS cluster used exclusively for SQL Server
2000 clustered instances. An application requires connectivity to external
Oracle datasources. Is it technically feasible create ...

We just migrated a large database from SQL 2000 ent ed. to SQL 2005 ent. ed.
This migration included moving to larger, faster hardware on an
active-passive clustered pair of Win 2003 servers (32 GB RAM, quad
processors, etc).

The nightmare has happened...  The passive node of a 2-node Active/Passive
SQL2K5 cluster had a critical drive failure and there is no recovery disk or
backup to restore from.  At this moment only the Active node is running (and
running fine).  I have a server with a clean OS ...

Say I am setting a 2 node cluster. One node is physically named ServerA and
the other physically named ServerB.
Now when i install MSCS, I take it we need to give it a cluster name right..
say we called it "ServerCluster". Now when we install SQL on top of it, is

Is there any article where one can set up say a 4 node cluster with 2 or 3
instances?
If I have a 4 node cluster with 2 instances and say instance 1 and 2 are
tied to node 1 and node 2 respectively... is there any priority where we can

We have traditionally used a rolling upgrade method for moving to new
hardware on a MS cluster.
We would add one new node tp an existing 2 node cluster and install SQL
Server to the new node.

I had installed an SQL 2000 Cluster on one of the two nodes server that
running Windows 2003 Ent version, but the other node server cannot join the
SQL cluster and the setup process always jump out of the screen that need to
input Admin username, password and domain name with no ...

First, Is it Necessary to create an MSDTC Group on your SQL Cluster with its
own name, IP and resources or just a good idea, I am planning on doing it, My
last SQL cluster did not have one But I didn't build it. I just want to be
sure.

I've inherited a Windows 2003/SQL Server 2005 active/passive cluster
that has MSDTC clustered in the same group as Cluster Name, Cluster IP
Address, and the quorum drive.
It's not configured to be "network enabled."

We are running clustered SQL 2000 SP4 on Win2003 SP1 with 4 instances
(DB2,DB3,DB4 on the problem node)
At the time of the events there was a large amount of processing being
undertaken on instance DB03

Hi, ever since last week I have a doubt about a type of clustering
implementation. Is it possible to cluster more than one SQL Server
instance. I mean i know it is possible to cluster one instance... so
that when that instance fails the other one enter into context be it