What are the DBCC Commands in SQL Server?

October 18, 2012

DBCC Commands in SQL Server are the Database Console Commands which are grouped into 4 categories:

  1. Maintenance
  2. Miscellaneous
  3. Informational
  4. Validation

1. Maintenance

  • DBCC CLEANTABLE
  • DBCC INDEXDEFRAG
  • DBCC DBREINDEX
  • DBCC SHRINKDATABASE
  • DBCC DROPCLEANBUFFERS
  • DBCC SHRINKFILE
  • DBCC FREEPROCCACHE
  • DBCC UPDATEUSAGE

2. Miscellaneous

  • DBCC dllname (FREE)
  • DBCC HELP
  • DBCC FREESESSIONCACHE
  • DBCC TRACEOFF
  • DBCC FREESYSTEMCACHE
  • DBCC TRACEON

3. Informational

  • DBCC INPUTBUFFER
  • DBCC SHOWCONTIG
  • DBCC OPENTRAN
  • DBCC SQLPERF
  • DBCC OUTPUTBUFFER
  • DBCC TRACESTATUS
  • DBCC PROCCACHE
  • DBCC USEROPTIONS
  • DBCC SHOW_STATISTICS

4.Validation

  • DBCC CHECKALLOC
  • DBCC CHECKFILEGROUP
  • DBCC CHECKCATALOG
  • DBCC CHECKIDENT
  • DBCC CHECKCONSTRAINTS
  • DBCC CHECKTABLE
  • DBCC CHECKDB
Advertisements

%d bloggers like this: