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

what is a join? : Sql server database administration

0 Answers  

What is the order in which the sql query is executed?

0 Answers  

How do you create an execution plan?

0 Answers  

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 Answers   247Customer,

How do I debug a stored procedure in sql server?

0 Answers  

Can we call future method from trigger?

0 Answers  

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 Answers  

What is pivot and unpivot?

0 Answers  

After the SQL installation what are the jobs will you configure?

1 Answers   G7 CR Technologies, IBM, Satyam,

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

How to trouble shoot if unable to connect SQL Server

0 Answers  

What is b tree index?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories