DBCC stands for Database Consistency Checker.

These commands are used to check the consistency of the database like validation tasks, maintenance and status checks.

For example –

1. DBCC CHECKALLOC – It is used to check that all pages are correctly allocated in database.

2. DBCC CHECKDB – It is used to check that

3. DBCC SQLPERF – It generates a report for the current usage of

4. DBCC SQLFILEGROUP – It used to check all the tables file group for any design.