Using multiple disks for parallel query performance

If temporary databases span multiple devices, as shown in Figure 6-2, you can take advantage of parallel query performance for some temporary tables or worktables.

Figure 6-2: tempdb spanning disks

Image shows three disks, disk_1, disk_2, and disk_3. disk_1 has its own tempdb, but disk_2 and disk_3 share a tempdb.