How do you use DBCC statements to monitor various aspects of
a SQL server installation?
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
Tell me what is the significance of null value and why should we avoid permitting null values?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What is data set in report?
Difference between LEN() and DATALENGTH() in sql server ?
Why use stored procedures in sql server?
How to list all user names in a database?
What are the different editions available in sql server 2000?
What is subreport?
How to how to convert numeric expression data types using the convert() function??
How to specify the collation for a character data type in ms sql server?
What is the xml datatype?
What is named query? : sql server analysis services, ssas
How to create an index on a view?
What are the types of stored procedures in an sql server?
What are the different types of sub-queries?