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
- 7431 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
Can we delete data from a view?
How to find the version of sql server? : sql server database administration
What is trace flag in sql server?
What is ms sql server service broker?
How to list all schemas in a database?
Where is trigger in sql server?
What does it mean if @@cursor_row returns a negative number?
How do you make a trace?
What is a constant or literal in ms sql server?
What are the elements of dbms?
How to create user messages with print statements in ms sql server?
What the class forname () does?
How to delete existing rows in a table?
Explain can you implement data mining in ssrs?
Why we use the openxml clause?
