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 engine group attribute values for all execution classes:
sp_showexeclass
classname priority engine_group engines --------- ---------- ------------- ----------- EC1 HIGH ANYENGINE ALL EC2 MEDIUM ANYENGINE ALL EC3 LOW LASTONLINE 0
Displays the attribute values of execution class EC1:
sp_showexeclass 'EC1'
classname priority engine_group engines ----------- ---------- ---------------------- ----------- EC1 HIGH ANYENGINE ALL
sp_showexeclass displays the execution class attributes and the engines in any engine group associated with execlassname. See the Performance and Tuning Guide for more information.
If execlassname is NULL or absent, sp_showexeclass displays the priority and engine group 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.
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
