What are the DBCC Commands in SQL Server?

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: