Spotlight on SAP ASE 2.12 - User Guide

Post-Threshold Sorts alarm

The Post Threshold Sorts alarm becomes active when a sort has been requested after the sort heap threshold has been reached. Sorts that start after the sort heap threshold has been reached may not receive all the memory they need to run efficiently. By adjusting the sort heap threshold and sort heap size configuration parameters, you can improve sort operations and overall system performance.

This alarm has been predefined with a Low severity level. The underlying metric for this alarm can be adjusted to suit your environment by using the Metric Editor.

What you can do

If post-threshold sort values are high, you can try the following possible solutions:

• Increasing sheapthres

   Or

• Making SQL query changes that allow applications to use fewer or smaller sorts.

If you are running Quest Central for DB2, you can easily obtain information about and edit the DB2 database configuration parameters defined for a specific database. In the object tree in the left pane of the Quest Central for DB2 database explorer, right-click the database name. Select Configure to display an alphabetized list of the configuration parameters and their values defined for the database. Select a parameter to display a brief description of the parameter and to edit its value.