I'm not sure if you mean the server is running or the sql server process is running (i.e. sqlservr.exe). The quickest way to check is to logon to the server...

Cluster Service must be running at all times on all nodes.

Err... Isn't that exactly what I wrote (although I used the word "virtual" rather than "logical")?

If the machine has the up-to-date BIOS design (according to Intel specs.) then my understanding is that the CPU's will enumerate as follows (on a 4 way physical machine):

real CPU...

I'm trying to look at the plan for a stored procedure that uses a temporary table. I'm doing this by entering the command "EXEC SP_NAME" and then pressing the "Display...

I've had two problems with my MSCS SQL Server cluster since I installed it in October, 2001.

1, If you have a database job (such as a sp) that is a...

As I understand it, only users with administrative privileges can administer a cluster. The cluster service does not need to be a *domain* admin, but it does need to be...

To add a little more detail here:

The cluster service has a resource monitor process ('sqsrvres') that attempts to logon to the cluster and execute a status command every so often....

[One more thank you for the concatenation trick.]

If there was an execution difference between

SET @X=7

and

SELECT @X=7

don't you think the optimizing query processor would replace the slow one with the quick...

I had a 3 month incident with Microsoft concerning this issue. The most likely cause is that your server was too busy to respond to the cluster's monitor process so...

When I did this, I just restored the user databases. This means you have to fix up the users in master and the jobs in MSDN, but otherwise it's pretty...

If you're coding a failure aware client, bear in mind that a big database with full recovery can take a while to come back online. Also remember that every client...

This is actually a group representing all processes running for "anonymous" network logons (e.g. ftp and www clients). These local accounts are created when IIS is installed and usually are...

That seems like a valid point, I'll grant you. But what exactly is the passive node doing and how does that load compare to running the active database server?

On...

For active/active it seems to be unreasonable to put DTC into one of the server instances. The asymmetry seems ugly to me.

For active/passive, maybe I'm just being dense, but what...