What's the advantage of moving MSDTC from the Cluster Group (where it is put when installed) to the server group in active/passive? i.e. Why bother to do this, rather than...

Apart from the install, I do 100% of my clustered server administration remotely.

I use terminal services alot of the time; but I also use cluadmin.exe and SQL EM remotely all...

Oh, another thing to exploit is that CPU is cheap and price data is typically *MASSIVELY* compressible. Standard compression algorithms often get you up to 95-98% compression (depending on the...

When I used to work at [Large Investment Bank], there was a prejudice against SQL based solutions for history time-series becuase of a "feeling" that SQL type data structures would...

I had this very same problem.

My cause was that I was running a very long running sp that used >95% cpu for over 20 minutes.

The sql server cluster...

AWE memory, as distinct from using /3GB, is out of the windows paged area and access is managed from the process itself, rather from the virtual memory manager subsystem. So...

The big drawback to your scheme would seem to be effective I/O performance.

Not only are your servers accessing remote storage; so you have speed issues for network bandwidth vs....

I don't know definitively, but it seems to me that this behaviour is not right.

If you move the Cluster Resource between nodes, the cluster IP number is going to...

Whoops: when counting disks, it looks like I forgot to include 7!

The system must be configured so that all the "clustered" resources can be moved between nodes. This means that the cluster quorum, DB logs and data must all reside on...

A typical SQL cluster looks like this:

Two servers each with hardware RAID1 (2 disks) for the OS installation.

One shared SCSI disk system with one RAID1 partition for the Quorum (2...

Small point, but you do not need WINS with Windows 2000 unless you're running a cluster. (You need it for a cluster because the cluster needs to dynamically change the...

I like the book, but I wouldn't sweat it too much as hardware is pretty cheap these days. You can get a $10K server from DELL with Dual 2.4GHz/512K Xeons...

p.p.s. One important point to highlight is that in the active/active configuration the two virtual servers are *not* sharing the same database. You need to build a federated database using...

Steve,

This is kind of verbose --- I hope it helps.

Yes. All you need is one PowerVault. You can group the storage on a PV into a single RAID monolithic set...