allow resource limits

allow resource limits controls the use of resource limits.

Summary Information

Default value

0 (off)

Valid values

0 (off), 1 (on)



Display level


Required role

System administrator

Configuration groups

Memory Use, SQL Server Administration

When the value is set to 1, the server allocates internal memory for time ranges, resource limits, and internal server alarms. The server also internally assigns applicable ranges and limits to user sessions. The output of showplan and statistics io displays the optimizer’s cost estimate for a query. Set allow resource limits to 0 to disable all resource limits.