DBCC (Database Console Command) Commands

 

It's a common question of DBA interview. I already have faced millions of time. HaHa Ha. DBCC is a series of statements in Transact-SQL programming language to check the physical and logical consistency of SQL Server database. We can divide in 4 major category or type...

DBCC command type...

1.    Informational DBCC command

2.       Validational DBCC command

3.       Maintenance DBCC command

4.       Miscellaneous DBCC command

 

1.       Informational DBCC commands

·         DBCC INPUTBUFFER              

·         DBCC SHOWCONTIG

·         DBCC OPENTRAN

·         DBCC SQLPERF

·         DBCC OUTPUTBUFFER

·         DBCC TRACESTATUS

·         DBCC PROCCACHE

·         DBCC USEROPTIONS

·         DBCC SHOW_STATISTICS

 

2.       Validation DBCC commands

·         DBCC CHECKALLOC

·         DBCC CHECKFILEGROUP

·         DBCC CHECKCATALOG

·         DBCC CHECKIDENT

·         DBCC CHECKCONSTRAINTS

·         DBCC CHECKTABLE

·         DBCC CHECKDB

 

3.       Maintenance DBCC commands

·         DBCC CLEANTABLE

·         DBCC INDEXDEFRAG

·         DBCC DBREINDEX

·         DBCC SHRINKDATABASE

·         DBCC DROPCLEANBUFFERS

·         DBCC SHRINKFILE

·         DBCC FREEPROCCACHE

·         DBCC UPDATEUSAGE

  

4.       Miscellaneous DBCC commands

·         DBCC dllname (FREE)

·         DBCC HELP

·         DBCC FLUSHAUTHCACHE

·         DBCC FREESESSIONCACHE

·         DBCC FREESYSTEMCACHE

·         DBCC TRACEOFF

·         DBCC TRACEON

·         DBCC IND

·         DBCC PAGE

 

             Stay Tuned!!!!!

               

--By Abhishek....