Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

CHECKDB Expand / Collapse
Posted Monday, June 23, 2008 9:30 PM


Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,041, Visits: 1
Comments posted to this topic are about the item CHECKDB
Post #522306
Posted Wednesday, June 25, 2008 2:00 AM


Group: General Forum Members
Last Login: Wednesday, April 20, 2016 3:23 AM
Points: 6,049, Visits: 1,407
Simple and right question.

Post #523084
Posted Thursday, September 4, 2008 6:40 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, September 20, 2016 10:24 AM
Points: 614, Visits: 628
hello Gurus,

My Question: for example: if you have a database which is static like northwind which is never going to change a lot. So when you run DBCC CHECKDB on northwind, command is still going to use tempdb? Because in books online it says that When there is lots of activities on the system at that time DBCC CHECKDB uses tempdb. Pls correct me if I am wrong.
Pls do reply to clear my doubts.
Post #563741
Posted Thursday, September 4, 2008 9:53 PM



Group: Administrators
Last Login: Today @ 1:59 PM
Points: 34,363, Visits: 18,582
It may or may not. Depends on what checkdb needs to do, the activity and resources available at the time it's run, etc.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #564312
Posted Friday, September 5, 2008 12:18 AM



Group: General Forum Members
Last Login: 2 days ago @ 5:18 AM
Points: 45,619, Visits: 44,147
Depends. TempDB's used for checking indexed views as well. Probably other things too.

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

Post #564348
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse