r all databases. Do not clear tempdb, or startup checkpoint
3620 Do not kill infected processes
3701 Allows dropping and creating of system indexes (DANGEROUS!)
4000 Crash server at next loop for recovery testing
4012 Boot without starting up checkpoint process
4013 Place a record into errorlog each time someone logs in to the server
5101 Engine 0 will perform all disk and network I/O.
5102 Prevents engine 0 from running any non-affinitied tasks
8399 Enable descriptive names for groups (dbcc monitor)
dbcc tune ( "parameter", value [, tablename] )
Sets buildmaster parameters. Probably not necessary as of System11, where the
old buildmaster parameters are now incorporated into sysconfigures (see
documentation on sp_configure).
dbcc undo ( dbid, pgnum, rownum )
dbcc update_tmode ( procname, tranmode )
Update transaction-mode in both sysobjects and DES for stored procedures.
Parameters
ParamDescriptionValid Values
procname stored procedure name
tranmode transaction mode unchained
chained
anymode
dbcc usedextents ( dbid, devtype, display )
Count or display the status of used/unused extents on specified devices.
Parameters
ParamDescriptionValid Values
dbid database ID
devtype type of device to check all show all extents
log show extents of allocation for the log
nonlog show extents of nonlog allocations
display what to report on 0 information about the extents
1 count of the extents