Parallel Recovery

Databases are recovered in parallel by multiple recovery tasks during start-up and failover.

Database recovery is an I/O-intensive process. The time to recover SAP ASE with parallel recovery depends on the bandwidth of the underlying I/O subsystem. The I/O subsystem should be able to handle SAP ASE concurrent I/O requests.

With parallel recovery, multiple tasks recover user databases concurrently. The number of recovery tasks is dependent on the configuration parameter max concurrently recovered db. The default value of 0 indicates that SAP ASE adopts a self-tuning approach in which it does not make any assumptions on the underlying storage architecture. Statistical I/O sampling methods determine the optimal number of recovery tasks depending on the capabilities of the underlying I/O subsystem. An advisory on the optimal number of recovery tasks is provided. If the configuration value is nonzero, SAP ASE spawns as many tasks as indicated by the configuration parameter and also by the number of open databases parameter.

During parallel recovery, the system administrator can force serial recovery by setting max concurrently recovered db to 1. The active recovery tasks drain out after completing the recovery of the database that is being worked on. The remaining databases are recovered serially.

See System Administration Guide, Volume 1 > Setting Configuration Parameters.