How do you use DBCC statements to monitor various aspects of
a SQL server installation?
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
What is the difference between lock, block and deadlock? : sql server database administration
What is transaction server consistency?
What is database isolation in sql server? : sql server database administration
What is the difference between stored procedure and user defined functions?
How do you handle datasets larger than 50 gb?
Which language is supported by sql server?
What is cursors? And what are the different types of cursor?
What are the database objects? : SQL Server Architecture
What is trigger in salesforce?
what are the core components of SSRS?
Difference between group by clause and having clause in SQL?
What is a transact-sql statement batch in ms sql server?
How many databases instances are there in sql server 2000?
What are the differences between decimal and float in ms sql server?
What are sql azure firewall rules?