DBCC 命令

DBCC activecursors [(spid)]DBCC addextendedproc (function_name, dll_name)DBCC addinstance (objectname, instancename)DBCC adduserobject (name)DBCC auditevent (eventclass, eventsubclass, success, loginname, rolename, dbusername, loginid)DBCC autopilot (typeid, dbid, tabid, indid, pages [,flag])DBCC balancefactor (variance_percent)DBCC bufcount [(number_of_buffers)]DBCC buffer ( {'dbname' | dbid} [, objid [, number [, printopt={0|1|2} ][, dirty | io | kept | rlock | ioerr | hashed ]]])DBCC bytes ( startaddress, length )DBCC cachestatsDBCC callfulltextDBCC checkalloc [('database_name'[, NOINDEX | REPAIR])] [WITH NO_INFOMSGS[, ALL_ERRORMSGS][, ESTIMATEONLY]]DBCC checkcatalog [('database_name')] [WITH NO_INFOMSGS]DBCC checkconstraints [( 'tab_name' | tab_id | 'constraint_name' | constraint_id )] [WITH ALL_CONSTRAINTS | ALL_ERRORMSGS]DBCC checkdb [('database_name'[, NOINDEX | REPAIR])] [WITH NO_INFOMSGS[, ALL_ERRORMSGS][, PHYSICAL_ONLY][, ESTIMATEONLY][, DBCC TABLOCK]DBCC checkdbts (dbid, newTimestamp)]DBCC checkfilegroup [( [ {'filegroup_name' | filegroup_id} ] [, NOINDEX] )] [WITH NO_INFOMSGS[, ALL_ERRORMSGS][, PHYSICAL_ONLY][, ESTIMATEONLY][, TABLOCK]]DBCC checkident ('table_name'[, { NORESEED | {RESEED [, new_reseed_value] } } ] )DBCC checkprimaryfile ( {'FileName'} [, opt={0|1|2|3} ])DBCC checktable ('table_name'[, {NOINDEX | index_id | REPAIR}]) [WITH NO_INFOMSGS[, ALL_ERRORMSGS][, PHYSICAL_ONLY][, ESTIMATEONLY][, TABLOCK]]DBCC cleantable ('database_name'|database_id, 'table_name'|table_id, [batch_size])DBCC cacheprofile [( {actionid} [, bucketid])DBCC clearspacecaches ('database_name'|database_id, 'table_name'|table_id, 'index_name'|index_id)DBCC collectstats (on | off)DBCC concurrencyviolation (reset | display | startlog | stoplog)DBCC configDBCC cursorstats ([spid [,'clear']])DBCC dbinfo [('dbname')]DBCC dbrecover (dbname [, IgnoreErrors])DBCC dbreindex ('table_name' [, index_name [, fillfactor ]]) [WITH NO_INFOMSGS]DBCC dbreindexall (db_name/db_id, type_bitmap)DBCC dbrepair ('dbname', DROPDB [, NOINIT])DBCC dbtable [({'dbname' | dbid})]DBCC debugbreakDBCC deleteinstance (objectname, instancename)DBCC des [( {'dbname' | dbid} [, {'objname' | objid} ])]DBCC detachdb [( 'dbname' )]DBCC dropcleanbuffersDBCC dropextendedproc (function_name)DBCC dropuserobject ('object_name')DBCC dumptrigger ({'BREAK', {0 | 1}} | 'DISPLAY' | {'SET', exception_number} | {'CLEAR', exception_number})DBCC errorlogDBCC extentinfo [({'database_name'| dbid | 0} [, {'table_name' | table_id} [, {'index_name' | index_id | -1}]])]DBCC fileheader [( {'dbname' | dbid} [, fileid])DBCC fixallocation [({'ADD' | 'REMOVE'}, {'PAGE' | 'SINGLEPAGE' | 'EXTENT' | 'MIXEDEXTENT'}, filenum, pagenum [, objectid, indid])DBCC flush ('data' | 'log', dbid)DBCC flushprocindb (database)DBCC free dll_name (FREE)DBCC freeproccache DBCC freeze_io (db)DBCC getvalue (name)DBCC help ('dbcc_command' | '?')DBCC icecapquery ('dbname', stored_proc_name [, #_times_to_icecap  (-1 infinite, 0 turns off)]) Use 'dbcc icecapquery (printlist)' to see list of SP's to profile. Use 'dbcc icecapquery (icecapall)' to profile all SP's.DBCC incrementinstance (objectname, countername, instancename, value)DBCC ind ( { 'dbname' | dbid }, { 'objname' | objid }, { indid | 0 | -1 | -2 } )DBCC indexdefrag ({dbid | dbname | 0}, {tableid | tablename}, {indid | indname})DBCC inputbuffer (spid)DBCC invalidate_textptr (textptr)DBCC invalidate_textptr_objid (objid)DBCC iotrace ( { 'dbname' | dbid | 0 | -1 }, { fileid | 0 }, bufsize, [ { numIOs | -1 } [, { timeout (sec) | -1 } [, printopt={ 0 | 1 }]]] )DBCC latch ( address [, 'owners'] [, 'stackdumps'])DBCC lock ([{'DUMPTABLE' | 'DUMPSTATS' | 'RESETSTATS' | 'HASH'}]|[{'STALLREPORTTHESHOLD', stallthreshold}])DBCC lockobjectschema ('object_name')DBCC log ([dbid[,{0|1|2|3|4}[,['lsn','[0x]x:y:z']|['numrecs',num]|['xdesid','x:y']|['extent','x:y']|['pageid','x:y']|['objid',{x,'y'}]|['logrecs',{'lop'|op}...]|['output',x,['filename','x']]...]]])DBCC loginfo [({'database_name' | dbid})]DBCC matview ({'PERSIST' | 'ENDPERSIST' | 'FREE' | 'USE' | 'ENDUSE'})DBCC memobjlist [(memory object)]DBCC memorymap DBCC memorystatusDBCC memospyDBCC memusage ([IDS | NAMES], [Number of rows to output])DBCC monitorevents ('sink' [, 'filter-expression'])DBCC newalloc - please use checkalloc insteadDBCC no_textptr (table_id , max_inline)DBCC opentran [({'dbname'| dbid})] [WITH TABLERESULTS[,NO_INFOMSGS]]DBCC outputbuffer (spid)DBCC page ( {'dbname' | dbid}, filenum, pagenum [, printopt={0|1|2|3} ][, cache={0|1} ])DBCC perflogDBCC perfmonDBCC pglinkage (dbid, startfile, startpg, number, printopt={0|1|2}, targetfile, targetpg, order={1|0})
DBCC pintable (database_id, tab
摘自论坛：http://www.sql.ru/forum/14779/trace-flag-2520-help-on-all-dbcc-commands