Stamey (7/23/2012)
Is CheckDB cumulative, in that whatever it did before is saved and it continues where it left off?
No.
I ask because it ran for 8 hours the previous day with no conclusion or results, which caused me to create this thread. Seems strange it would run in less time on the subsequent attempt.
IO load, CPU load. CheckDB uses a lot of both, if there's concurrent activity it's likely to run slower (and so's everything else)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability