How about perfmon data piped into a sql table?

use the varbinary(max) datatype which holds BLOB objects

The best way to test....unplug stuff

No seriously, walk over to the servers, unplug the network from one, check the state of the cluster. Power one down, check the state of...

Don't forget the indexes in...

Couple of questions:

Are the locking and blocking issues associated with a single table or multiple tables?

Aside from the locks and blocks are you seeing deadlock issues?

When the row update occurs...

Doesn't coldfusion use DSN's to connect to the database servers? As such could you not just change the DSN to point to the other database server?

It would be a new log, not an update of the old.

Add the service account as an option, that will help out with the memory paging that...

Do you have "lock pages in memory" enabled on the SQL server? That's frequently a cause of that problem.

Again, logs?

It doesn't just bomb without telling you why somewhere.

When I've done this I have always had all the partitions in the same filegroup, so it was a simple case to switch out the data, however I always found...

That's nice...a good way of working around the slowness.

Just curious, were the filegroups on different drives? I'm not exactly sure how the partitioning works, but if you have the two...

Just a note on the slang thing, it's interesting how a lot of these things come about, for example "Limey's". This comes from a time when ships sailing the Atlantic...

Two big thumbs up for this.

:w00t:

You can perform a manual uninstall based upon the Microsoft information found at http://support.microsoft.com/kb/909967