Size of Tables and Importance of Data

dbcc checkstorage is a database-level operation. If only a few tables contain critical data or data that changes often, you may want to run the table- and index-level dbcc commands more frequently on those tables than you run dbcc checkstorage on the entire database.

Before you run a dbcc command, answer the following questions about your data: