Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Tempdb Expand / Collapse
Author
Message
Posted Monday, January 20, 2014 12:08 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 4, 2014 4:46 PM
Points: 2,018, Visits: 10,973
The referenced article states that you cannot perform DBCC CHECKALLOC or DBCC CHECKCATALOG on tempdb. I presumed that since DBCC CHECKDB performs both of those functions (cf. http://technet.microsoft.com/en-us/library/ms176064.aspx), one couldn't run DBCC CHECKDB against TempDB either.

But, there's a line buried in that article saying,
"Running DBCC CHECKDB against tempdb does not perform any allocation or catalog checks and must acquire shared table locks to perform table checks. This is because, for performance reasons, database snapshots are not available on tempdb. This means that the required transactional consistency cannot be obtained."
So, special handling for TempDB.

Always read the fine print....



Rob Schripsema
Accelitec, Inc
Post #1532766
Posted Monday, January 20, 2014 4:29 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:21 PM
Points: 7,928, Visits: 9,653
Good question, but I thought it was rather easy - provided one looks for the three things which one certainly can't do to tempdb and avoids worrying about whether one can or can't do each one of the other four.

Tom
Post #1532816
Posted Tuesday, January 21, 2014 7:57 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 7:59 AM
Points: 579, Visits: 621
Good Question, made me feel good about all those sessions I attended on the TempDB.
Post #1533097
Posted Sunday, January 26, 2014 11:14 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Thank you, for your overwhelming response.

Cheers!


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1534849
Posted Monday, January 27, 2014 3:23 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, November 20, 2014 4:29 AM
Points: 3,559, Visits: 2,671
Good one as wasn't aware of all of them. Thanks free mascot.
Post #1534914
Posted Friday, January 31, 2014 7:55 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 2:48 PM
Points: 204, Visits: 390
DUH forgot about the full backup... however; on another note, yes you can run CHECKDB but the DBCC CHECKALLOC and DBCC CHECKCATALOG cannot be run against the tempdb which are also part of the CHECKDB... jus sayin
Post #1536790
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse