Summary information |
|
|---|---|
Default value |
10 |
Range of values |
0–100 |
Status |
Dynamic |
Display level |
Intermediate |
Required role |
System administrator |
Configuration group |
Cache Manager |
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. 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. See Chapter 6, “Tuning Asynchronous Prefetch” in the Performance and Tuning Series: Basics.
