Enable Indexes to be Rebuilt in Parallel During Recovery
Performance impact: Variable
On multi-processor systems, set
RecoveryThreads to
minimum(number of CPUs available, number of indexes) to enable indexes to be rebuilt in
parallel if recovery is necessary.
If a rebuild is necessary, progress can be viewed in the user log. Setting
RecoveryThreads to a number larger than the number of CPUs
available can cause recovery to take longer than if it were single-threaded.