Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
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 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
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

  • No labels
Page: Consistency Checkers and Fixers Page: DBCC allocdump Page: DBCC anchors Page: DBCC cachedataremove Page: DBCC cacheremove Page: DBCC checktable Page: DBCC checkverify Page: DBCC connection_hangup Page: DBCC cursorinfo Page: DBCC dam Page: DBCC dbcacheremove Page: DBCC dbinfo Page: DBCC dbreboot Page: DBCC dbrepair Page: DBCC dbtable Page: DBCC deleteplan Page: DBCC des Page: DBCC descount Page: DBCC engine Page: DBCC extentcheck Page: DBCC extentdump Page: DBCC extentzap Page: DBCC findnotfullextents Page: DBCC findstranded Page: DBCC fix_text Page: DBCC flushlog Page: DBCC gam Page: DBCC gettrunc Page: DBCC housekeeper Page: DBCC ides Page: DBCC indexalloc Page: DBCC istraceon Page: DBCC latch Page: DBCC listoam Page: DBCC locateindexpgs Page: DBCC lock Page: DBCC lock_release Page: DBCC lock_requeue Page: DBCC logprint Page: DBCC markp Page: DBCC memdump Page: DBCC mempool Page: DBCC orphantables Page: DBCC page Page: DBCC pdes Page: DBCC pglinkage Page: DBCC printtolog Page: DBCC Procbuf Page: DBCC prsqlcache Page: DBCC prtipage Page: DBCC pss Page: DBCC purgesqlcache Page: DBCC rebuild_text Page: DBCC rebuildextents Page: DBCC reset_cached_plan_stats Page: DBCC resource Page: DBCC serverlimits Page: DBCC set_identity_burn_max Page: DBCC settrunc Page: DBCC showrecovery Page: DBCC sqltext Page: DBCC stacktrace Page: DBCC stackused Page: DBCC tablealloc Page: DBCC textalloc Page: DBCC thresholds Page: DBCC toggle_tsql_syntax Page: DBCC trace Page: DBCC traceflags Page: DBCC traceoff Page: DBCC traceon Page: DBCC tune Page: DBCC upgrade_object Page: DBCC usedextents Page: DBCC user_stats Page: DBCC xdes Page: DBCC xdeshash Page: DBCC xdespool Page: Formally Documented Page: Memory Datastructure Displayers Page: Replication Related