If you suspect problems in your database, try running the stored procedure sp_iqcheckdb.
This procedure reads every database page from disk into memory and does various consistency checks. However, depending on the size of your database, the check can take a long time to run.
The sp_iqdbstatistics stored procedure displays the database statistics collected by the most recent execution of the sp_iqcheckdb procedure.