sp_showexeclass

Displays the execution class attributes and the thread pool name associated with the specified execution class.

Considerations for process mode

In process mode, sp_showexeclass displays the execution class attributes and the engines in any engine group associated with the specified execution class.

Syntax

sp_showexeclass [execlassname]

Parameters

Examples

Usage

If execlassname is NULL or absent, sp_showexeclass displays the priority and thread pool attribute values for all execution classes, including the attribute values of the system-defined classes EC1, EC2, and EC3.

Permissions

Any user can execute sp_showexeclass. 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_dropexeclass
sp_showcontrolinfo
sp_unbindexeclass