• CXPacket waits are an indication of parallelism. Not to say that parallelism is the issue, just that it's going on. Something you'd have to validate.

    The latch waits are absolutely and indication of disk issues. If you're seeing them during loads, it sort of makes sense because that's when an exclusive lock is most likely to be taken out, but that's what you're seeing, IO.

    "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