Displays the execution class attributes and the thread pool name associated with the specified execution class.
In process mode, sp_showexeclass displays the execution class attributes and the engines in any engine group associated with the specified execution class.
sp_showexeclass [execlassname]
is the name of an execution class.
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
Displays the attribute values of execution class EC1:
sp_showexeclass 'EC1'
classname priority threadpool ------------------ --------- --------------- EC1 HIGH syb_default_pool
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.
Any user can execute sp_showexeclass. Permission checks do not differ based on the granular permissions settings.
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 |
|
System procedures sp_addexeclass, sp_bindexeclass, sp_dropexeclass, sp_showcontrolinfo, sp_unbindexeclass
