Use dbcc checkstorage to check:
Allocation of text valued columns
Page allocation and consistency
OAM page entries
An OAM page for each partition exists
Pointer consistency
Text-valued columns and text-column chains
dbcc checkstorage runs checks against the database on disk. If a corruption is only in memory, dbcc checkstorage may not detect the corruption. To ensure consistency between two dbcc checkstorage runs, execute checkpoint before running dbcc checkstorage. However, doing this may turn a transient memory corruption into a disk corruption.
