Database consistency check for 2 TB database taking 14 hours 20 mins

Question

1)Database size is 2 TB 2)Largest Tables (only one large table) Total pages it has - 274190987 3)Execution for this single DB consistency check is 13 hours 38 minutes 23 seconds. ---most of the time we had to cancel the execution just to avoid conflicts with business times i e 8 AM. 4)Job starts at 5:30 PM So this job most of the time conflicts with business hours ie 8 AM 5)So, I am looking for some appropriate action so this could finish before the business start time & we would not require canceling this execution. Looking forward for some ideas to tackle this case. Thanks, in advance! Dhaval

Answer 1

Restore a backup of the database to a different environment and run DBCC there. This is something that quite a few sites do. Not only to off-load the DBCC from the production machine, but it also serves to verify the backup.

It is worth mentioning that if DBCC takes longer time than usual, this is often a token of corruption, because DBCC performs a lot of extra action to analyse that corruption.