Interview Questions

How do you use DBCC statements to monitor various ASPects of a SQL Server installation?

.NET Database ,COM interop,and .NET deployment questions and answers


(Continued from previous question...)

How do you use DBCC statements to monitor various ASPects of a SQL Server installation?

Database Consistency Checker (DBCC) - Is a statement used to check the logical and physical consistency of a database, check memory usage, decrease the size of a database, check performance statistics, and so on. Database consistency checker (DBCC) ensures the physical and logical consistency of a database, but is not corrective. DBCC can help in repairing or checking the installation in case of any failure.

(Continued on next question...)

Other Interview Questions