global async prefetch limit

Summary information

Default value

10

Range of values

0–100

Status

Dynamic

Display level

Intermediate

Required role

System Administrator

The global async prefetch limit parameter specifies the percentage of a buffer pool that can hold the pages brought in by asynchronous prefetch that have not yet been read. This parameter 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. For more information, see “Tuning Asynchronous Prefetch” in the Performance and Tuning Guide: Optimizer and Abstract Plans.