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
- 7504 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 pessimistic lock and optimistic lock?
What does the update command do?
Explain powershell included in sql server 2008?
When do you think a developer should use sql server-based cursors?
How to disable triggers using "disable trigger"?
State the difference between local and global temporary tables?
How to create user messages with print statements in ms sql server?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
How the authentication mode can be changed?
What are the elements of dbms?
What is the osql utility?
What is transaction server isolation?
How many types of attribute relationships are there? : sql server analysis services, ssas
How do you check sql server is up and running?
