Post reply

How DBCC Checkdb works internally?

  • June 1, 2013 at 2:36 am

    #273359

    Can someone please help me understand how DBCC checkdb runs internally? Does it run in tempdb or does it run within the datafile itself? And how much space is needed to run the Checkdb (i mean, does it need the total size of the database? or only data or index) ?? Also is database accessible while running Checkdb?

    Thanks,

    Pradeep

  • June 1, 2013 at 3:29 am

    #1620267

    Get yourself a copy of SQL Server 2008 Internals by Kalen Delaney, there's an entire chapter on how CheckDB works.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply