Threading for sorting data in parallel is a resource-intensive process that behaves
differently from
threaded processing. Use caution when you assign a value for MAXSORTTHREADS=. If a parallel sort uses
one
thread for every CPU on the server, the sort job might starve other jobs of resources. For
better performance during parallel sort operations, configure values for SORTSIZE=
(in MB) and MAXSORTTHREADS= (in number of threads) so that the ratio of SORTSIZE=
to MAXSORTTHREADS= is between 256 MB per thread and 1 GB per thread.
Use MAXSORTTHREADS= with MAXWHTHREADS= to balance your system load. Parallel sorting
can be a resource-intensive process, and parallel
WHERE processing tends to be more
I/O intensive. In most cases, parallel WHERE processing
tasks require more threads than parallel sorting tasks.