When SAP ASE is installed, the default recovery isolation mode is
databases, which marks a database as suspect and takes
the entire database offline if it detects any corrupt pages.
Isolating Suspect Pages
To isolate the suspect pages so that only they are taken offline—while the rest of the database remains accessible to users—use sp_setsuspect_granularity to set the recovery isolation mode to page.
Raising the Number of Suspect Pages Allowed
The suspect escalation threshold is the number of suspect pages at which recovery marks an entire database suspect, even if the recovery isolation mode is page.