Share via

checkDB and TempDB

Mark Gordon 926 Reputation points
2023-12-14T16:26:46.7+00:00

Fellow DBA's

years ago I remember that checkdb actually creates a snapshot of the db then runs a check on that.

I know it uses tempdb for sorting for the output but is the processing of the data done inside tempdb?

Thx.

MG

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
    2023-12-15T22:05:38.7333333+00:00

    Some googling took me to https://www.sqlskills.com/blogs/paul/the-curious-case-of-setting-up-a-server-for-dbcc-checkdb/ where Paul says:

    This is because a lot of the information generated by DBCC CHECKDB spills out into a worktable in tempdb,

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.