ASE : Setting Process Priorities

With Sybase 11.9.5 and above, you can set the run class for processes to LOW, MEDIUM, or HIGH.

Here's a sample call which sets the priority for a specific spid:

sp_setpsexe 14, 'priority', 'LOW'

Here are sample calls which define a class, and sets the priority for a login, forever:

sp_addexeclass 'rpt_class',LOW,null,'ANYENGINE'

sp_bindexeclass 'bjenner','lg','null','rpt_class'