Problem: How to check the consistency of a SQL Server database.
DBCC checkdb WITH no_infomsgs, all_errormsgs;
This Command can put overhead on the database.
Normally schedule to run at off peak hours.
See the database consistency history report by right click the database>select Reports>Select Standard Reports>Select Database Consistency history
Figure 1: Database Consistency History