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 install Adaptive Server, the default value for global async prefetch limit is 10 (percent).
A per-pool override, set with sp_poolconfig. To see the limits set for each pool, use sp_cacheconfig.
See Chapter 5, “Setting Configuration Parameters,” in the System Administration Guide: Volume1.
Changing asynchronous prefetch limits takes effect immediately, and does not require a restart. You can configure the global and per-pool limits in the configuration file.
