allow resource limits controls the use of resource limits.
|
Summary Information |
|
|---|---|
|
Default value |
0 (off) |
|
Valid values |
0 (off), 1 (on) |
|
Status |
Static |
|
Display level |
Comprehensive |
|
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.