DBCC stands for database consistency checker. We use these commands to check the consistency of the databases, i.e., maintenance, validation task and status checks.
[b]DBCC CHECKDB -[/b] Ensures that tables in the db and the indexes are correctly linked. [b] DBCC CHECKALLOC -[/b] To check that all pages in a db are correctly allocated. [b]DBCC SQLPERF -[/b] It gives report on current usage of transaction log in percentage. [b]DBCC CHECKFILEGROUP - [/b]Checks all tables file group for any damage.