enable large pool for load configures the use of large buffer pools during the recovery phase for load database and load transaction commands.
|
Summary Information |
|
|---|---|
| Default value | 0 (off) |
| Valid values | 0 (off), 1 (on) |
| Status | Dynamic |
| Display level | Comprehensive |
| Required role | System administrator |
| Configuration group | SQL Server Administration |
However, if you set enable large pool for load to 1, it uses a value of 1 regardless of what you set enable functionality group to.
See enable functionality group.