sp_showplan  sp_spaceused

Chapter 1: System Procedures

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.

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





Copyright © 2005. Sybase Inc. All rights reserved. sp_spaceused

View this book as PDF