sp_showcontrolinfo

Displays information about thread pool assignments, bound client applications, logins, and stored procedures.

Considerations for process mode

When you configure the SAP ASE server for process mode, sp_showcontrolinfo displays information about engine group assignments, bound client applications, logins, and stored procedures.

Syntax

sp_showcontrolinfo [object_type, object_name, spid ]

Parameters

Examples

Usage

There are additional considerations when using sp_showcontrolinfo:
  • When used with no parameters, sp_showcontrolinfo displays information about all user-assigned thread pool assignments, bound client applications, logins, and stored procedures. When used with the object_type parameter, sp_showcontrolinfo provides information on an individual basis about application, login, or stored procedure bindings to an execution class, thread pool compositions, and session-level attribute bindings. See Distributing Engine Resources in the Performance and Tuning Series: Basics.

  • When run in process mode, sp_showcontrolinfo replaces thread_pool with the engine_group and engine columns.

  • Unless object_type is PR, execute sp_showcontrolinfo from the master database. If object_type is PR, execute sp_showcontrolinfo from the database in which the procedure resides.

  • If object_type is:

    • nullsp_showcontrolinfo displays execution class information for objects that match the other parameters.

    • DFobject_name and spid should be null, and sp_showcontrolinfo shows information about the user-defined default execution class.

  • If object_name is null, sp_showcontrolinfo displays the binding information for all applications, logins, and stored procedures.

  • If spid is null, sp_showcontrolinfo displays execution class information for objects that match the other parameters.

See also isql in the Utility Guide.

Permissions

Any user can execute sp_showcontrolinfo. 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_addexeclass
sp_bindexeclass
sp_clearpsexe
sp_dropengine
sp_dropexeclass
sp_showexeclass
sp_showpsexe
sp_unbindexeclass
sp_who