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 performs various consistency checks. However, depending on the size of your database, the check can take a long time to run.
sp_iqdbstatistics displays the database statistics collected by the most recent execution of sp_iqcheckdb.