Sort Buffer Waits

Reports contention for the sort buffers used for parallel sorts. Parallel sort buffers are used by:

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.