x

Is there any impact to tempdb if we run checkdb on 800GB database?

Is there any impact to tempdb if we run checkdb on 800GB database?
more ▼

asked Sep 18 '12 at 08:53 PM in Default

narendba gravatar image

narendba
550 19 37 42

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
Yes, DBCC CHECKDB has a very large impact on TEMPDB as well as your disk subsystem.
more ▼

answered Sep 18 '12 at 09:00 PM

Tim gravatar image

Tim
35.5k 32 41 138

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)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1936

asked: Sep 18 '12 at 08:53 PM

Seen: 647 times

Last Updated: Sep 27 '12 at 10:26 AM