Wednesday, February 08, 2012

Checking on CheckDB - How to check CheckDB's progress

Alkampfer's Place - Check progress of DBCC CHECKDB

"If you issue a DBCC CHECKDB on a big database to verify for consistency errors, it will take a long time to complete, but the Management Studio windows usually does not give you any hint about how long does it take, or a percentage progress. Luckily enough sql server has a Dynamic Management View that can solve your problem.

This is the SQL code to visualize progress of the operation




So much I don't know... sigh. Have to remember this the next time I do a DBCC CheckDB.

No comments: