Several factors, including database use, backup schedule, table size, and importance of
data, determine how often you should run dbcc commands, and which ones to
run.
Database Use
Consider your overall database when determining which dbcc commands to run, and when to run them.
Backup Schedule
The more often you back up your databases and dump your transaction logs, the more data you can recover after a failure. You must decide how much data you are willing to lose in the event of a disaster, and develop a dump schedule to support that decision.
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.