Fault verification for dbcc checkstorage faults

The dbcc checkstorage command, introduced in Adaptive Server version 11.5, checks the consistency of database objects without blocking access by other tasks. Since user activity can produce soft faults, dbcc checkstorage attempts to resolve the fault by a second check; if the fault persists, it is recorded in the dbccdb database. Since heavy database use during dbcc checkstorage operations can lead to lengthy fault reports, the dbcc checkverify command introduced in version 11.9.2 rechecks these faults, while holding a lock on the object, in order to eliminate the soft faults from the list of faults.