• Also don't forget that you don't just bottleneck on the disks. You also bottleneck on the disk controllers and the connections to the disks. I/O is a giant rats nest and with the scale you're talking, you're going to have to get serious about it. I'd suggest getting a hardware expert to help out on this one.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning