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 . D B C C 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
Connecting, Sharing and Discovering