How to predict DBCC CHECKDB finish time

Question: I’ve set off a dbcc checkdb command : DBCC CHECKDB () WITH NO_INFOMSGS, ALL_ERRORMSGS on a SQL Server database due to a unexpected server outage. It appears to be taking a longer than usual time. Is there a method I can use to view the percentage complete of the CHECKEB process?

Answer: Yes you can view the CHECKDB percent complete. Querying the sys.dm_exec_requests DMV reveals some useful information. This information includes elapsed time and Estimated Finish time.    To filter out this process from all the other SQL Server processes, you’ll need the session id

An example query to view the DBCC CHECKDB percent complete

SELECT session_id,percent_complete,DATEADD(MILLISECOND,estimated_completion_time,CURRENT_TIMESTAMP) Estimated_finish_time,
(total_elapsed_time/1000)/60 Total_Elapsed_Time_MINS ,
DB_NAME(Database_id) Database_Name ,command,sql_handle
FROM sys.dm_exec_requests where session_id = 62

Some sample output from the query

Read More on DBCC CHECKDB

SQL Server – DBCC CHECKDB FAQ - SQL Server DBA

SQL Server - DBCC checktable - SQL Server DBA

List SQL Server DBCC commands using trace 2520 – documented and undocumented commands