sp_showpsexe

Description

Displays execution class, current priority, and affinity for all client sessions running on Adaptive Server.

Syntax

sp_showpsexe [spid]

Parameters

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.

Examples

Example 1

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

Example 2

Displays the application name, login name, current priority, and engine affinity of the process with spid 5:

sp_showpsexe 5

Usage

Permissions

Any user can execute sp_showpsexe.

See also

System procedures sp_addengine, sp_addexeclass, sp_bindexeclass, sp_clearpsexe, sp_dropengine, sp_dropexeclass, sp_showcontrolinfo, sp_showexeclass, sp_unbindexeclass