wow!... that's a lot of both CPU and I/O, kinda the perfect storm

Any chance of taking a look at the execution plan?