• Jason,

    As hinted above, be very careful with SSD manufacturer quoted perf numbers.

    SSD drives all perform brilliantly when first installed. But over time you start to notice a massive perf drop. This is due to their read/write characteristics. While they can read in small chunks ie 4K they need to erase/write in much larger blocks. So even changing 1 bit could require copying 512K, erasing it all & then writing.

    Sure physical disks also fragment when they are nearly full, but we solve that by allocating a few huge files to SQL when the drive is fairly empty.

    In short, do your benchmarking carefully, keep ~50% of the SSD drive free, or your random write pref can really suck.