Interested to Buy Any Domain ? << Click Here >> for more details...
How do you use DBCC statements to monitor various aspects of
a SQL server installation?
- 1 Answers
- 7352 Views
- I also Faced
- E-Mail Answers
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 are the properties of primary key?
What is the xml datatype?
How to assign new column names in a view?
What are sql azure firewall rules?
What is the difference between drop table and truncate table?
How to find the service pack installed? : sql server database administration
What are the advantages of passing name-value pairs as parameters?
what is the difference between delete table and truncate table commands? : Sql server database administration
Can I disable or restrict ssrs export formats (rendering formats)?
Who developed sql server?
What are drilldown reports?
Explain the disadvantages of cursors?
What is meant by indexing files?
How to fine-tune reports?
Explain how to maintain a fill factor in existing indexes?
