What is the use of DBCC commands?

What is the use of DBCC commands?

What is the use of DBCC commands?

View Answers

November 18, 2010 at 5:16 PM

Hi,

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.

DBCC command options (Database consistency check) -

DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.

DBCC CHECKALLOC - To check that all pages in a db are correctly allocated.

DBCC SQLPERF - It gives report on current usage of transaction log in percentage.

DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

Thanks,









Related Tutorials/Questions & Answers:
What is the use of DBCC commands?
What is Hibernate and what is its use?
Advertisements
What is Hibernate and what is its use?
What is the use of DESC in SQL?
What is the use of friend function?
What is use of a abstract variable?
What is use of a abstract variable?
What is the use of Bluetooth technology
What is the use of Java?
what is use of push in javascript
what is use of push in javascript
What is the use of Hibernate?
What is the use of Hibernate is used?
What is the use of CASCADE CONSTRAINTS?
What is the use of data science?
What is the use of JDK
what is the use of Spring Framework
what the use of taglib - JSP-Servlet
What is the use of Hibernate Native SQL?
What is use of method overloading and overriding?
What is the real use of Java Program
What is the real use of Java Program
What is the use of Hibernate Framework in Java
What is the use of R Programming Language?
What is Java?
What is use of big data analytics in healthcare?
What is the use of Print or Echo Function in PHP?
what is the use of clone() in real time scenario?
what is the use of Hibernate Sessionfactory close() method?
What is maven dependency and how to use it in project?
What is Angular and Why Use It?
What is Java Platform
why we use ^ operator in sql, and what is the meaning of that operator?
What do I need to do to use a MSSQL-Server with Web-Harvester?
What is the use of MySQL, MS SQL in Web Hosting paradigm?
What is Java programming used for?
What is Java programming used for?
What is Java programming used for?
What is JSON?
What is Ajax?
What is JUnit?
What is an Iterator?
What is DTS?
What is deprecated?
what is bit
what is pytest
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection

Ads