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
- 7446 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 is the template in sql?
What are the encryption mechanisms in sql server?
Scalability, Availability, Integration with internet, etc.)?
Can a unique index be created on a column, which contains null?
What are pessimistic lock and optimistic lock?
What is a functions and types in sql server?
How to download and install sql server 2005 books online?
How to override dml statements with triggers?
How to receive returning result from a query?
Explain about system stored procedure?
Mention the differences between local and global temporary tables.
Can we use having clause without group by?
Why are you getting errors when creating a new odbc dsn?
Can you explain powershell included in sql server 2008?
What are “phantom rows”?
