New system procedures

The system procedures in Table 5-16 support the resource limits feature.

Table 5-16: New system procedures for resource limits

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.