How long DBCC CHECKDB process runs on SQL Server instance?
In order to keepup the database logical and physical integrity of all the objects, you must run the DBCC statement such as DBCC CHECKALLOC, DBCC CHECKTABLE and DBCC CHECKCATALOG. Overall you can do this with another statement DBCC CHECKDB that will avoid you executing the above 3 statements in a row.
Have you ever wondered how long your Database Maintenance tasks are taking time?
Do you have a window schedule to perform such tasks?
Bear in mind SQL Server 2005 uses the TEMPD extensively when you talk about database maintenance such as running DBCC CHECKDB. In very rare cases you might need to run CHECKDB against tempdb which will not perform any allocation or catalog checks, as you cannot afford downtime of SQL Server service that uses TEMPDb a lot.
SQL Server Internals guru Paul Randal posted much useful statistics on CHECKDB run-times from his series of CHECKDB From Every Angle.