I tried turning this on, and now I no longer get the transaction deadlock errors, but I simply get timeouts instead. Which again makes me think that there's a...

As I understand snapshot isolation, the tradeoff is that it creates a lot of overhead in tempdb as well as extra storage space in each row. So, mind if...

Thank you for your advice. I didn't really mean to ask you guys to debug my code though (I can rewrite it in this instance, and I'm trying to...

I'm currently monitoring this and I'll post when I have more data (probably when we have a little bit more load, although I'll try to add some load and see...

These are all in our main database.

So this is not really a disk issue, but rather likely to be an issue of table design and blocking?

This does occur...

The output appears to consistently be "Is Not PFS, GAM, or SGAM page".

Thanks to everybody for the suggestions.

As an online game, we're probably closer to OLAP than OLTP. I can't post a query plan of one particularly bad query...

I can't answer your question directly, because I have no experience with offline rebuilds. What I might suggest though is that the downtime is a problem, you might want...

Thank you for the suggestion.

I think this might be the explanation. In the console (short) version, only the 376 rows of match (the big table involved here)...