sp_showpsexe

Description

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

Considerations for process mode

sp_showpsexe displays engine information instead of task affinity.

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
----   ----------  ----------   ----------  ----------------   ---------------
   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

Permissions

Any user can execute sp_showpsexe.

Auditing

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

  • 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

See also

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