During a server restart after a planned or unplanned shutdown, or during HA failover, a significant amount of time can be spent on database recovery. The fast recovery feature enables databases to be available earlier and minimizes database downtime. It can aid in recovery from planned shutdowns, unplanned crashes, and HA failover.
Fast recovery enables the following changes to Adaptive Server:
Brings engines online earlier after all system databases are recovered.
Enhances performance of database recovery.
Recovers multiple databases in parallel by making use of available server resources. This is controlled by the configuration parameter max concurrently recovered db.
Provide for multiple checkpoint tasks at runtime that can run concurrently to minimize the work that needs to be done at recovery time. This is controlled by the configuration parameter number of checkpoint tasks.
New global variable @@recovery_state to determine if Adaptive Server is in recovery.
New option strict | relax to the stored procedure sp_dbrecovery_order.
For more information see “Fast Recovery” in the System Administration Guide.
