We've move a number of WIN2K/SQL2K servers to WIN2K3 SP1 with no issues at all. The present count is 10 of 25 servers.

 "Multiple datafiles should help with latch contention"

Could you please enlighten me onthis point ...

I have 25 servers and 400+ databases all in a MSX/TSX environment presently (I've been using it since v7.0 !!!). One 'gotcha is that the authentication used for MSX/TSX was...

Have you tried the Sybase website ??? You may have to register, but you then have access to their knoledgebase.

Good Day Shawn, I stand corrected - we have an Enterprise license agreement so we can actually do this.

It's not that bad ... locks and couple of memory thiongs in sp)_configure are still the only ones that require reboots. The reason locks reared it's ugly head is because...

Excellent catch SQLBill ... I guess my 'senility' lost the last half of the problem posted ...

Index splitting anybody ?

I'm no expert in SQL2K5 (yet) but check out the results of:

sp_configure 'locks'

maybe it needs to be 'tweaked' ...

Yes.

EM is not 'real-time', it's more of a 'snap-shot'. Try 'refresh' on 'databases' ...

How large is the table (#rows) ? could you post the DDL for the table and indexes ? It is possible that the index(es) were 'splitting' ...

Just some additional information on what the threshhold of a disk throughput problem should be.

It's usually when the avg disk queue is greater than 2 * number of disks...

It's not the horse vinny, it was the first 100 or so servers that I built that taught me the virtues of standards and defined processes ... as a matter...

Since you changed your Windows username, my guess is that you have to go in and add your nre Windows username to the SQL Server (and probably remove your old...