Page tree
Skip to end of metadata
Go to start of metadata

DBCC allocdump - displays the contents of an allocation page
DBCC anchors - displays the anchors for a database
DBCC cacheremove - removes data from data cache and frees descriptors
DBCC cachedataremove - removes data from data cache for a table
DBCC checkalloc - verifies allocation structures for all tables in a database
DBCC checkcatalog - verifies relations between system tables
DBCC checkdb - verifies index structures for all tables in a database
DBCC checkmdcache - verifies the metadata cache
DBCC checkobjcache - checks caches for buffers belonging to objects not bound to the cache.
DBCC checkstorage - does most of what checkalloc does with a fast parallel scan
DBCC checktable - verifies index structures for a table

DBCC checkverify - resolves suspect faults after a run of checkstorage
DBCC connection_hangup - closes a connection (site handler) to a remote server
DBCC cursorinfo - displays information about a cursor
DBCC dam - related to the sysdams system table used for incremental dumps
DBCC dbcacheremove - frees the dbtable for an open but unused database
DBCC dbinfo - displays database information persistently stored on disk
DBCC dbreboot - shutdown individual database 
DBCC dbrepair - various methods to repair specific issues in a database 
DBCC dbtable - displays the memory structure for a currently open database
DBCC deleteplan
DBCC des - displays an object descriptor memory structure
DBCC descount - Display the bucket number and the chain size for longest chains from the hash table.
DBCC engine
DBCC extentcheck - displays all extents allocated to an object
DBCC extentdump - displays the contents of an extent structure
DBCC extentzap - deallocates all extents for a particular objid-indid pair
DBCC findnotfullextents
DBCC findstranded 
DBCC fix_text
DBCC flushlog
DBCC gam
DBCC gettrunc - display the current log transfer manager markers
DBCC housekeeper
DBCC ides
DBCC indexalloc
DBCC istraceon
DBCC listoam
DBCC locateindexpgs
DBCC latch
DBCC lock
DBCC lock_release
DBCC lock_requeue

DBCC logprint - writes a message to the server errorlog. 
DBCC markprocs
DBCC memdump - manually generate a shared memory dump
DBCC mempool
DBCC orphantables
DBCC page - prints the contents of a page
DBCC pdes - prints contents of a partition descriptor structure(pdes)
DBCC pglinkage - follows chains of linked pages
DBCC pss - displays a PSS structure (user connection)
DBCC printtolog writes a message to the server errorlog. 
DBCC procbuf
DBCC prsqlcache - prints information on contents of sql cache
DBCC prtipage - print an index page
DBCC purgesqlcache - clear the contents of statement cache
DBCC rebuild_text
DBCC rebuildextents
DBCC reset_cached_plan_stats
DBCC resource - prints contents of resource structure.
DBCC serverlimits - print out a list of hardcoded limits
DBCC set_identity_burn_max - used to reset identity column values.
DBCC settrunc
DBCC showrecovery
DBCC sqltext
DBCC stacktrace - prints the stack for a process
DBCC stackused - Displays the largest size a stack has grown to.
DBCC tablealloc
DBCC textalloc
DBCC thresholds
DBCC toggle_tsql_syntax
DBCC trace
DBCC traceflags - displays list of currently active trace flags
DBCC traceoff - turns a trace flag off
DBCC traceon - turns a trace flag on
DBCC tune
DBCC upgrade_object
DBCC usedextents
DBCC user_stats
DBCC xdes
DBCC xdeshash
DBCC xdespool

  • No labels