Private Sort heap allocated (TotSortHeapAlloc)

This parameter indicates the total number of memory pages allocated for all sorts in progress for the selected database instance’s partition. This parameter can be used to tune the sheapthres and sortheap configuration parameters.

Recommendation:

If the value of this parameter equals or exceeds the value of the sheapthres parameter, then sorts are not getting the full sort heap as defined by the sortheap configuration parameter.

By using indexes when appropriate, you can reduce the amount of sorting required, thereby reducing the amount of sort heap utilization.

Default parameter attributes