Asynchronous prefetch limits are configured as a percentage of the pool in which prefetched but unused pages can be stored. There are two configuration levels:
The server-wide default, set with the configuration parameter global async prefetch limit. When you first install, the default value for global async prefetch limit is 10 (percent).
For more information, see of the System Administration Guide.
A per-pool override, set with sp_poolconfig. To see the limits set for each pool, use sp_cacheconfig.
For more information, see of the System Administration Guide.
Changing asynchronous prefetch limits takes effect immediately, and does not require a reboot. Both the global and per-pool limits can also be configured in the configuration file.
