recovery prefetch size

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




Display level


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.