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_drop_resource_limit |
sp_setpsexe |
sp_addexeclass |
sp_drop_time_range |
sp_showcontrolinfo |
sp_add_resource_limit |
sp_familylock |
sp_showexeclass |
sp_add_time_range |
sp_help_resource_limit |
sp_showpsexe |
sp_bindexeclass |
sp_lock |
sp_unbindexeclass |
sp_clearpsexe |
sp_modify_resource_limit |
sp_setpsexe |
sp_dropexeclass |
sp_modify_time_range |
sp_who |
sp_dropengine |
sp_setpglockpromote |
|
sp_dropglockpromote |
sp_plan_dbccdb |
See the System Administration Guide for more information about the system procedures that accomplish these administrative tasks.
