Summary information |
|
|---|---|
Default value |
0 (off) |
Valid values |
0 (off), 1 (on) |
Status |
Static |
Display level |
Comprehensive |
Required role |
System Administrator |
allow resource limits controls the use of resource limits. 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 sp_configure displays the optimizer’s cost estimate for a query. Set allow resource limits to 0 to disable resource limits.
