sp_showpsexe

Displays execution class, current priority, and thread pool affinity for all client sessions running on the SAP ASE server.

Considerations for process mode

sp_showpsexe displays engine information instead of task affinity.

Syntax

sp_showpsexe [spid]

Parameters

Examples

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:

InformationValues
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

Related reference
sp_addengine
sp_addexeclass
sp_bindexeclass
sp_clearpsexe
sp_dropengine
sp_dropexeclass
sp_showcontrolinfo
sp_showexeclass
sp_unbindexeclass