Eu aş sugera să evaluaţi şi soluţii bazate pe striping (RAID-0), adică să faceţi din mai multe discuri fizice un singur disc logic.
Citat din
Designing Partitions to Improve Query Performance:
"It may be tempting to map your partitions to filegroups, each accessing a different physical disk drive, in order to improve I/O performance. When SQL Server performs data sorting for I/O operations, it sorts the data first by partition. Under this scenario, SQL Server accesses one drive at a time, and this might reduce performance. A better solution in terms of performance is to stripe the data files of your partitions across more than one disk by setting up a RAID. In this way, although SQL Server still sorts data by partition, it can access all the drives of each partition at the same time. "
Răzvan