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

Do you know what is openxml in sql server?

0 Answers  

How to create a new schema in a database?

0 Answers  

what is node in sql server?

2 Answers   CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,

Does the unique constraint create an index?

0 Answers  

After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

0 Answers   Cognizant,

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

0 Answers  

how would you improve etl (extract, transform, load) throughput?

0 Answers   LinkedIn,

What is compression - row-level and page-level compression?

0 Answers  

What is database normalization?

7 Answers   Deloitte, Digicel, JPMorgan Chase, Verifone,

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 Answers  

application server is slow what may be the problem

0 Answers   Microsoft,

What is nonclustered index on computed columns?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories