|
Is there any impact to tempdb if we run checkdb on 800GB database?
(comments are locked)
|
|
Yes, DBCC CHECKDB has a very large impact on TEMPDB as well as your disk subsystem. Thanks tim, internally how it would running... Can you explain
Sep 18 '12 at 09:03 PM
narendba
My best advice to understanding the internals of tempdb is to do a quick search in google for Paul Randal checkdb. On the SQLSkills.com website is Pauls blog and he has many detailed articles about checkdb as well as tempdb.
Sep 18 '12 at 09:17 PM
Tim
Also a copy of the book SQL Server 2008 Internals can give you a good idea how CHECKDB works.
Sep 19 '12 at 10:23 AM
Grant Fritchey ♦♦
I agree with Grant Fritchey. I paid something like eight dollars for that book in Google Play and now has it as an app in my Android tab.
Sep 19 '12 at 01:31 PM
Magnus Ahlkvist
I'd go for the book and blog recommendations already mentioned. But in easy words: "CHECKDB uses extensive storage in tempdb for reading and writing information about the database it's checking" So for every step the CHECKDB process performs, the tempdb is also involved because a so called work table get created which stores different information throughout the process. More information here: http://www.sqlskills.com/blogs/paul/post/How-does-DBCC-CHECKDB-WITH-ESTIMATEONLY-work.aspx
Sep 27 '12 at 10:26 AM
DirkHondong
(comments are locked)
|

