sp_showpsexe

Considerations for process mode

sp_showpsexe displays engine information instead of task affinity.

Syntax

sp_showpsexe [spid]

Parameters

spid – is the SAP ASE 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
----   ----------  ----------   ----------  ----------------   ---------------
   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

Example 2 – 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

Usage

There are additional considerations when using sp_showpsexe:

sp_showpsexe displays execution class, current priority, and affinity for all sessions (objects with an spid). See 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 the SAP ASE 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.

Permissions

Any user can execute sp_showpsexe. Permission checks do not differ based on the granular permissions settings.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Information	Values
Event	38
Audit option	exec_procedure
Command or access audited	Execution of a procedure
Information in `extrainfo`	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect