These system procedures are used for:
Reporting on locks and the users currently running processes
Altering the lock promotion thresholds of a table or database
Creating and reporting on resource limits and time ranges
Creating and reporting on execution classes and engine groups
Planning the layout of the dbccdb database
The procedures in this category are:
sp_addengine
sp_addexeclass
sp_add_resource_limit
sp_add_time_range
sp_bindexeclass
sp_clearpsexe
sp_dbextend
sp_dropexeclass
sp_dropengine
sp_dropglockpromote
sp_drop_resource_limit
sp_drop_time_range
sp_familylock
sp_help_resource_limit
sp_lock
sp_modify_resource_limit
sp_modify_time_range
sp_setpglockpromote
sp_plan_dbccdb
sp_setpsexe
sp_showcontrolinfo
sp_showexeclass
sp_showpsexe
sp_transactions
sp_unbindexeclass
sp_ssladmin
sp_who
See the System Administration Guide for more information about the system procedures that accomplish these administrative tasks.
