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:
Post a Comment