Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

How to make a remote connection in a database?

0 Answers  

Is it possible to create trigger on views?

0 Answers  

What are the components of sql server service broker?

0 Answers  

What happens if null values are involved in arithmetic operations?

0 Answers  

What are the options which must be set to allow the usage of optimistic models?

0 Answers  

What is the use of group by clause?

0 Answers  

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

7 Answers   Microsoft,

How to use order by with union operators in ms sql server?

0 Answers  

Can you type more than one query in the query editor screen at the same time?

0 Answers  

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

0 Answers   IBM,

Define master database?

0 Answers  

How to create database with physical files specified in ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories