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

execlassname – is the name of an execution class.

Examples

Example 1 – Displays the priority and thread pool for all execution classes:

sp_showexeclass

classname            priority      threadpool
------------------   ---------     ---------------
EC1                       HIGH    syb_default_pool
EC2                     MEDIUM    syb_default_pool
EC3                          LOW     syb_default_pool

Example 2 – Displays the attribute values of execution class EC1:

sp_showexeclass 'EC1'

classname            priority      threadpool
------------------   ---------     ---------------
EC1                         HIGH      syb_default_pool

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:

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