dbcc checkstorage

dbcc checkstorage runs checks against the database on disk.

Use dbcc checkstorage to check:

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.

The advantages of using dbcc checkstorage are:
dbcc checkstorage is different from the other dbcc commands in that it requires:

dbcc checkstorage does not repair any faults. After you run dbcc checkstorage and generate a report to see the faults, you can run the appropriate dbcc command to repair the faults.