Displays or sets the maximum number of suspect pages that Adaptive Server allows in a database before marking the entire database suspect.
sp_setsuspect_threshold [dbname [, threshold]]
is the name of the database for which you want to display or set the suspect escalation threshold. The default is the current database.
indicates the maximum number of suspect data pages that recovery will allow before marking the entire database suspect. The default is 20 pages. The minimum is 0.
Sets the maximum number of suspect pages to 5. If there are more than 5 suspect pages, recovery will mark the entire database suspect:
sp_setsuspect_threshold pubs2, 5
Displays the current and configured settings for the suspect escalation threshold for the pubs2 database:
sp_setsuspect_threshold pubs2
Displays the current and configured settings for the recovery fault isolation threshold for the current user database:
sp_setsuspect_threshold
You must be in the master database to set the suspect escalation threshold with sp_setsuspect_threshold.
If you do not specify the number of pages, Adaptive Server displays the current and configured settings. The current setting is the one that was in effect the last time recovery was executed in the database. The configured setting is the one that will be in effect the next time recovery is executed in the database.
The permission checks for sp_setsuspect_threshold differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be a user with own database privilege on the database to set the escalation threshold. Any user can execute sp_setsuspect_threshold to display settings. |
Granular permissions disabled |
With granular permissions disabled, you must be a user with sa_role to set the the escalation threshold. Any user can execute sp_setsuspect_threshold to display settings. |
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
|---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
System procedures sp_forceonline_db, sp_forceonline_page, sp_listsuspect_db, sp_listsuspect_page, sp_setsuspect_granularity
