I hate the situation where I have started a DBCC CHECKDB and I don’t know for how long time it has been running. Well, I have created this very small T-SQL statement that you can run.
selectÂ session_id,Â command,Â percent_complete
- DBCC CHECKALLOC
- DBCC CHECKTABLE
- DBCC CHECKATALOG
dbccÂ checkdb(‘adventureworks2012’)Â withÂ Estimateonly
Change adventure works to your database. Â On my server, the result is: