x
login about faq Site discussion (meta-askssc)

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
480 5 14 27

(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
31.7k 23 32 116

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.

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



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x1843

asked: Sep 18 '12 at 08:53 PM

Seen: 375 times

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

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.