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.
For more information on running and using the sp_iqcheckdb and sp_iqdbstatistics stored procedures, see “Database verification” in Chapter 13, “System Recovery and Database Repair.”
