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 Friday, August 20, 2010 10:02 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, July 10, 2014 12:49 PM
Points: 1,676, Visits: 1,754
Good question, thank you. I got it wrong because sadly I did not read the question carefully enough, and performed was the key. Running it does not produce any error, i.e.

use tempdb;
go

dbcc checkalloc with no_infomsgs;
go

reports "Command(s) completed successfully."

The question asked performed not ran, and BOL's verdict is clear:

In SQL Server 2005 and later, running DBCC CHECKALLOC against tempdb does not perform any checks.


Oleg
Post #972658
Posted Friday, August 20, 2010 12:17 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 11:05 AM
Points: 21,348, Visits: 15,023
Thanks for the question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #972741
Posted Friday, September 17, 2010 1:05 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 12, 2013 2:07 PM
Points: 168, Visits: 38
It has more that can't perform like:
Adding filegroups and Backing up or restoring the database
Post #988515
Posted Wednesday, March 7, 2012 1:37 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 10:52 PM
Points: 483, Visits: 244
Interesting question on the TempDB. Back to basics and the url below under the 'Restrictions' states all the facts too.

URL: http://msdn.microsoft.com/en-us/library/ms190768.aspx

Thanks
Post #1263261
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse