Looks a lot better, but i think you still have a borderline IO bottleneck. What's your disk layout? (phycisal drives, RAID, file locations)

p.s. What are your memory setting now? (boot.ini...

Where can you find what?

To trace the source of deadlocks. switch traceflag 1204 or...

Reality? What's that? 😉

Jeff Moden (7/9/2008)

---

I always have the clustered index on something that maintains the order of inserts so that the inserts go to the...

Best for what?

Writing books?

Teaching a class?

Managing a database?

Shouldn't take that long. I've got a 800 GB database that restores in just over an hour. If it's really slow, check your disk speed and performance

You can restore with...

DBRindex updates the stats with full scan. What I always advise against is doing a sampled update stats (the default) after a reindex, because the update stats can leave the...

Test your backups after you make them. An untested backup is more dangerous than no backup at all.

Make sure you're running log backups if you need to be able to...

I would suggest calling MS's customer support people. This kind of error is very hard for us to help you with. (details here - http://support.microsoft.com/kb/295539)

Logging a call does cost, but...

Doesn't matter. All updateusage does is...

This just got posted today. Very useful

http://blogs.msdn.com/psssql/archive/2008/07/08/sql-server-i-o-bottleneck-i-don-t-have-one-yes-you-do.aspx

Have you done an UPDATE STATISTICS?

gravittl (7/9/2008)

---

As a DBA who manages on different platforms and databases than just SQL Server, the downside I see is that anytime I see a quote from anyone tagged as...

Why would you change the compatibility level after moving a database to another server?

Mani Singh (7/9/2008)

---

Adding to it:

sometimes, the Deadlocks might resolve by themselves in time, but if you kill a long waiting deadlock, you might end up with a Phantom Process/lock and...

Go for the 64bit Xeon. The itanium's not worth the extra hassles that it will cause.