The system procedures in Table 5-16 support the resource limits feature.
System Procedure |
Description |
---|---|
sp_add_resource_limit |
Creates a resource limit. |
sp_add_time_range |
Creates a named time range. |
sp_configure |
|
"allow resource limits" |
Signals the server to allocate internal memory for time ranges, resource limits, and internal server alarms. It also signals the server to internally assign applicable ranges and limits to user sessions. When this option is set to 1 (on), sp_configure displays the optimizer’s cost estimate for a query. The default is 0 (off). |
sp_drop_resource_limit |
Drops a resource limit. |
sp_drop_time_range |
Drops a named time range. |
sp_help_resource_limit |
Displays resource limits in the current server. |
sp_modify_resource_limit |
Modifies a resource limit. |
sp_modify_time_range |
Modifies a named time range. |