global async prefetch limit

global async prefetch limit specifies the percentage of a buffer pool that can hold the pages brought in by asynchronous prefetch that have not yet been read.

Summary Information

Default value


Range of values




Display level


Required role

System administrator

Configuration group

Cache Manager

global async prefetch limit sets the limit for all pools in all caches for which the limit has not been set explicitly with sp_poolconfig.

If the limit for a pool is exceeded, asynchronous prefetch is temporarily disabled until the percentage of unread pages falls below the limit. See Performance and Tuning Series: Basics > Tuning Asynchronous Prefetch.