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'
Extra Topic: <a href=http://www.rocket99.com/sybase/rc.html>Click here</a> for a Sybase RC script sample.
|
|
