Configure SAP ASE Priority Level

The housekeeper garbage collection task typically operates at the priority level of an ordinary user, competing for CPU time with ordinary user tasks, preventing the list of empty pages from growing faster than the housekeeper can delete them.

However, if SAP ASE is configured for threaded mode, use the sp_bindexeclass 'sv' object type to change the server-wide priority setting for the housekeeper wash task. Set the priority to the EC1, EC2, EC3 level or define a new user-created execution class. This example sets the housekeeper wash task to the highest, EC1, priority:

sp_bindexeclass 'HK WASH', 'sv', NULL, 'EC1'

Use sp_setpsexe to set the priority level for the housekeeper task for the session if SAP ASE is configured for threaded or process mode.

This example sets the priority level for the housekeeper wash task (with a spid of 8) to HIGH for the current session:

sp_setpsexe 8, 'priority', 'HIGH'

See the Reference Manual: Procedures.