recovery prefetch size sets the look-ahead size (in numbers of log records) to be used by the recovery prefetch scan.
|
Summary Information |
|
|---|---|
|
Default value |
0 (use dynamic prefetch) |
|
Range of values |
0–20,000 |
|
Status |
Dynamic |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration group |
SQL Server Administration |
Set to 0 if the scan is to determine the look-ahead size dynamically, or to a value > 0 if the look-ahead size is to be set to a specific number of log records to look-ahead.