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. By default, it is set to 20 pages in a single database. Use sp_setsuspect_threshold to change the suspect escalation threshold. See Reference Manual: Procedures
You configure recovery fault isolation and the suspect escalation threshold at the database level.
This example shows that the recovery isolation mode for the pubs2 database was page and the escalation threshold was 20 the last time recovery ran on this database (the current suspect threshold values). The next time recovery runs on this database, the recovery isolation mode is page and the escalation threshold is 30 (the configured values).
sp_setsuspect_granularity pubs2
DB Name Cur. Suspect Gran. Cfg. Suspect Gran. Online mode ------- ------------------ ------------------ ----------- pubs2 page page read/write
sp_setsuspect_threshold pubs2
DB Name Cur. Suspect threshold Cfg. Suspect threshold ------------- ------------------------ ---------------------- pubs2 20 30
With no arguments, sp_setsuspect_granularity and sp_setsuspect_threshold display the current and configured settings for the current database, if it is a user database.