Database
Consistency Checker (DBCC) commands gives us valuable insight into what's
going on inside SQL Server system. There are below DBCC Commands we use day to day Activity .
INFORMATIONAL
|
MAINTENANCE
|
INTERNAL
|
MEMROY
|
|
DBCC HELP
|
DBCC CHECKALLOC
|
DBCC AUDITEVENT
|
DBCC MEMORYSTATUS
|
|
DBCC CONCURRENCYVIOLATION
|
DBCC CHECKCATALOG
|
DBCC LOCKOBJECTSCHEMA
|
DBCC FREEPROCCACHE
|
|
DBCC DES
|
DBCC CHECKCONSTRAINTS
|
DBCC CALLFULLTEXT
|
DBCC FREESESSIONCACHE
|
|
DBCC MEMUSAGE
|
DBCC CHECKDB
|
DBCC ADDINSTANCE
|
DBCC FREESYSTEMCACH
|
|
DBCC MEMORYSTATUS
|
DBCC CHECKFILEGROUP
|
DBCC SETINSTANCE
|
||
DBCC PROCCACHE
|
DBCC CHECKTABLE
|
DBCC INCREMENTINSTANCE
|
TROUBLESHOOTING
|
|
DBCC UPDATEUSAGE
|
DBCC CLEANTABLE
|
DBCC DELETEINSTANCE
|
DBCC CHECKIDENT
|
|
DBCC BUFCOUNT(6)
|
DBCC DBREINDEX
|
TUNNING
|
DBCC dllname
|
|
DBCC USEROPTIONS
|
DBCC INDEXDEFRAG
|
DBCC ADDEXTENDEDPROC
|
DBCC INPUTBUFFER
|
|
DBCC RESOURCE
|
DBCC NEWALLOC
|
DBCC DROPCLEANBUFFERS
|
DBCC OPENTRAN
|
|
DBCC TRACEON (3604)
|
DBCC SHOWCONTIG
|
DBCC FREEPROCCACHE
|
DBCC FLUSH
|
|
DBCC SHOW_STATISTICS
|
DBCC SQLPERF
|
DBCC OUTPUTBUFFER
|
||
DBCC SHRINK_DATABASE
|
DBCC SQLMGRSTATS
|
DBCC EXTENTINFO
|
||
DBCC SHRINKFILE
|
DBCC PINTABLE
|
DBCC LOG
|
||
DBCC LOGINFO
|
DBCC UNPINTABLE
|
DBCC DBRECOVER
|
||
DBCC ERRORLOG
|
DBCC FLUSHPROCINDB
|
DBCC REBUILD_LOG
|
||
DBCC DBREINDEXALL
|
DBCC SHOW_STATISTICS
|
DBCC STACKDUMP
|
||
DBCC DETACHDB
|
DBCC SHOWCONTIG
|
Happy
Reading
@SumanJha
-->
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757