eric.lyons (8/28/2012)
And yet, on a job interview I was very surprised to learn about the HOURS passing waiting for a VLDB to come on line because of dbcc.
I'd be very surprised to learn that too, because it's not true.
Oh, it's very possible for a DB to take hours to come online. 13 hours is the worst I've seen (1TB database), but it's not because of CheckDB. It's the database recovery process (crash recovery) taking forever due to huge transaction, very fragmented log or both. Probably both.
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