Displays execution class, current priority, and thread pool affinity for all client sessions running on Adaptive Server.
sp_showpsexe displays engine information instead of task affinity.
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 ---- ---------- ---------- ---------- ---------------- --------------- 5 NULL NULL NULL LOW syb_default_pool 6 NULL NULL NULL MEDIUM syb_default_pool 7 NULL NULL NULL LOW syb_default_pool 26 isql sa EC2 MEDIUM syb_default_pool
Displays the application name, login name, current priority, and engine affinity of the process with spid 5:
sp_showpsexe 5
spid appl_name login_name exec_class current_priority task_affinity ---- ---------- ---------- ---------- ---------------- --------------- 5 NULL NULL NULL LOW syb_default_pool
sp_showpsexe displays execution class, current priority, and affinity for all sessions (objects with an spid). See Chapter 4, “Distributing Engine Resources,” in Performance and Tuning Series: Basics.
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. Permission checks do not differ based on the granular permissions settings.
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
|---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
System procedures sp_addengine, sp_addexeclass, sp_bindexeclass, sp_clearpsexe, sp_dropengine, sp_dropexeclass, sp_showcontrolinfo, sp_showexeclass, sp_unbindexeclass
