Q3.2: DBCC Command Reference

• allocdump( dbid, page )
• bhash( { print_bufs | no_print }, bucket_limit )
• buffer( [ dbid ][, objid ][, nbufs ], printopt = { 0 | 1 | 2 }, buftype )
• bytes( startaddress, length )
• checkalloc[( dbname [, fix | nofix ] ) ]
• checkcatalog[( dbname )]
• checkdb[( dbname [, skip_ncindex ] ) ]
• checktable( tablename | tabid [, skip_ncindex ] )
• corrupt( tablename, indid, error )
  • 1133 error demonstrates that a page we think is an oam is not
  • 2502 error shows multiple references to the same page
  • 2503 error shows a breakage in the page linkage
  • 2521 error shows that the page is referenced but is not allocated on the extent page
  • 2523 error shows that the page number in the page or catalog entries are out-of-range for the database
  • 2525 error shows that an extent objid/indid do not match what is on the page
  • 2529 error shows a page number out-of-range for the database or a 605 style scenario
  • 2540 error occurs when a page is allocated on an extent but the page is not referenced in the page chain
  • 2546 error occurs when an extent is found for an object without an of its pages being referenced (a stranded extent)
  • 7939 error occurs when an allocation page which has extents for an object are not reflected on the OAM page
  • 7940 error occurs when the total counts in the OAM page differ from the actual count of pages in the chain
  • 7949 error is similar to a 7940 except that the counts are on an allocation page basis
• cursorinfo(cursor_level, cursor_name) where
  • cursor_level - level of nesting. -1 is all nesting levels
• dbinfo( [ dbname ] )
• dbrepair( dbid, option = { dropdb | fixindex | fixsysindex }, table, indexid )
• dbrepair( dbid, ltmignore)
• dbtable( dbid )
• delete_row( dbid, pageid, delete_by_row = { 1 | 0 }, rownum )
• des( [ dbid ][, objid ] )
• engine(eng func) where eng func may be:
  • "online"
  • "offline"
• extentcheck( dbid, objid, indexid, sort = {1|0} )
• extentdump( dbid, page )
• extentzap( dbid, objid, indexid, sort )
• findnotfullextents( dbid, objid, indexid, sort = { 1 | 0 } )
• fix_al( [ dbname ] )
• help( dbcc_command )
• ind( dbid, objid, printopt = { 0 | 1 | 2 } )
• indexalloc(tablename|tabid, indid, [full | optimized | fast],[fix | nofix])
• listoam(dbid, table_id, indid) - may supply dbname/tablename rather than id
• locateindexpgs( dbid, objid, page, indexid, level )
• lock - print out lock chains
• log( [dbid][,objid][,page][,row][,nrecords][,type={-1..36}],printopt={0|1} )
• memusage
• netmemshow( option = {1 | 2 | 3} )
• netmemusage
• newalloc( dbname, option = { 1 | 2 | 3 } )
• page( dbid, pagenum [, printopt={0|1|2} ][, cache={0|1} ][, logical={1|0} ] )
• pglinkage( dbid, start, number, printopt={0|1|2}, target, order={1|0} )
• pktmemshow( option = {spid} )
• procbuf( dbid, objid, nbufs, printopt = { 0 | 1 } )
• prtipage( dbid, objid, indexid, indexpage )
• pss( suid, spid, printopt = { 1 | 0 } )
• rebuildextents( dbid, objid, indexid )
• rebuild_log( dbid, 1, 1) - careful as this will cause large jumps in your timestamp values used by log recovery.
• resource
• setkeepalive(# minutes) - for use on Novell with TCP/IP.
• settrunc('ltm','ignore') - this command may be usefull for a dba who is dumping and loading a database that has replication set on for the original db.
• show_bucket( dbid, pageid, lookup_type )
• tab( dbid, objid, printopt = { 0 | 1 | 2 } )
• tablealloc(tablename|tabid, [full | optimized | fast],[fix | nofix])
• traceoff( tracenum [, tracenum ... ] )
• traceon( tracenum [, tracenum ... ] )
• tune( option, value ) - switch on any option immediately without having to reboot the SQL Server. Switches correspond to the old (pre-System 11) buildmaster -yall minus the c prefix

  For example option may be:

  • indextrips
  • oamtrips
  • datatrips
  • schedspins
  • bufwashsize
  • sortbufsize
  • sortpgcount
  • maxscheds
  • max_retries
• undo( dbid, pageno, rowno )