1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How do you use DBCC statements to monitor various aspects of
a SQL server installation?

Question Posted / guest


How do you use DBCC statements to monitor various aspects of a SQL server installation?..

Answer / 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

More SQL Server Interview Questions

What is difference between joins and subqueries?

0 Answers  

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

0 Answers   Facebook,

Is there any difference between primary key and unique with the not null condition?

0 Answers  

What is index fragmentation in ms sql server?

0 Answers  

When cursors are useful?

0 Answers  




What is ms sql server service broker?

0 Answers  

Why use triggers?

0 Answers  

What are three SQL keywords used to change or set someone?s permissions?

3 Answers  

How to connect a database with sql express.?

0 Answers   MCN Solutions,

Why I am getting this error when dropping a database in ms sql server?

0 Answers  

What is update locks?

0 Answers  

What is Schema in Database?

1 Answers   Cap Gemini,

For more SQL Server Interview Questions Click Here
Categories