Local Asynchronous Prefetch Percentage and sp_poolconfig

The default value for a pool’s asynchronous prefetch percentage is set by the configuration parameter global async prefetch limit. The pool limit always overrides the global limit.

To disable prefetch in a pool (if the global limit is a nonzero number), set the pool’s limit to 0.

See the Performance and Tuning Guide for information on the performance impact of changes to the asynchronous prefetch limit.