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.
