Two guesses, possibly out of date statistics on the tables in question or possibly something up with your I/O sub-system since you're seeing an I/O error.

So if you don't have enough log space to do the delete in a single step, break it up.

Maybe the statistics are out of date on the QA server leading to different execution plans? I know, truncating tables & all, but... Or, maybe statistics have changed sufficiently in...

There are a fairly large number of performance measures. The best documentation I have on that is in my book on query tuning. There's a link below. It also covers...

Koen Verbeeck (6/16/2014)

---

Sean Lange (6/16/2014)

---

Koen Verbeeck (6/16/2014)

---

Evil Kraig F (6/16/2014)

---

Any chance one of y'all with inroads to the powers that be at RedGate could get someone to update the spam...

With log buffer waits, it's hitting conflicts with other processes in and around the log. It might just be slow.

Are there waits associated with the process? It's likely that it's just taking a long time or that it's blocked.

In general, I'd go with the first query. I think the optimizer will figure it out in most circumstances, but that assumes you have an enforced referential constraint in...

Based on the amount of information you have shown, it could be SQL Server. The reads are quite a bit higher I production. I'd suggest getting the execution plan from...

And are there differential backups? If so, this stuff could be breaking your backup chain, which could lead to all sorts of fun when you try to recover.

There are a number of tools you can set up to track changes to the system. If you want to track individual queries you can use extended events or trace....

Kind of a shame to not let others see the question or provide a solution. Others could benefit from whatever issue you hit.

SQL Server 2008 has a system_health extended event session. I'm pretty sure it's capturing information from your deadlock called a deadlock graph. You'll need to query the files to get...

And they did. Well, not that hard, but a loss is...

Spoilsport.

England plays today!

WHOOOOP!!!