Worker processes for merge-join sorts

For merge joins, one consumer process is assigned for each device in tempdb; if there is only one device in tempdb, two consumer processes are used. The number of producers depends on the number of partitions in the worktable, and the setting for max parallel degree: