This section reports contention for the sort buffers used for parallel sorts. Parallel sort buffers are used by:
Producers – the worker processes returning rows from parallel scans.
Consumers – the worker processes performing the parallel sort.
If the number of waits is high, you can configure number of sort buffers to a higher value.
See Chapter 10, “Using Statistics to Improve Performance,” in Performance and Tuning: Query Processing and Abstract Plans for guidelines.
