Displays execution class, current priority, and affinity for all client sessions running on Adaptive Server.
sp_showpsexe [spid]
is the Adaptive Server session ID for which you want a report. The spid must belong to the application or login executing sp_showpsexe. Use sp_who to list spids.
Displays execution class, current priority, and affinity for all current client sessions:
sp_showpsexe
spid appl_name login_name exec_class current_priority task_affinity ----- ----------- ----------- ---------- ---------------- ------------- 1 isql sa EC1 HIGH NONE 5 NULL NULL LOW NULL 7 ctisql sa EC2 MEDIUM NONE 8 ctisql sa EC2 MEDIUM NONE
Displays the application name, login name, current priority, and engine affinity of the process with spid 5:
sp_showpsexe 5
sp_showpsexe displays execution class, current priority, and affinity for all sessions (objects with an spid). For more information, see the Performance and Tuning Guide.
If the spid is NULL or absent, sp_showpsexe reports on all sessions currently running on Adaptive Server.
sp_showpsexe does not report information for the following system processes: deadlock, checkpoint, network, auditing, and mirror handlers. It does display information for the housekeeper spid.
Any user can execute sp_showpsexe.
System procedures sp_addengine, sp_addexeclass, sp_bindexeclass, sp_clearpsexe, sp_dropengine, sp_dropexeclass, sp_showcontrolinfo, sp_showexeclass, sp_unbindexeclass
