How do you use DBCC statements to monitor various aspects of
a SQL server installation?
- 1 Answers
- 7026 Views
- I also Faced
- E-Mail Answers
Answer Posted / thiyagaraj.ramaswamy
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
CHECKDB - Ensures that tables in the db and the indexes are
correctly linked.and 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.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
When to use Inner join & when to use subquery?
What is reference section?
How to make conditional sum in ssrs?
What is the name of reporting services config file and what’s it’s used for?
write an SQL query to list the employees who joined in the month of January?
What is de-normalization in sql database administration? Give examples?
How to enter date and time literals in ms sql server?
What do you understand by intent locks?
What is the difference between varchar and nvarchar?
What do you understand by mirroring?
Explain what are the different index configurations a table can have?
What stored by the tempdb ? : sql server database administration
Tell me the phases a transaction has to undergo?
What is the command dbcc checkdb used for?
What is row_number()?
