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 |
10 |
|
Range of values |
0–100 |
|
Status |
Dynamic |
|
Display level |
Intermediate |
|
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.