Appendix B. DBCC Commands

by Orryn Sledge

IN THIS APPENDIX

  • Quick Reference

  • Reading the Output from DBCC Commands

  • Resolving Errors Reported by DBCC

  • Essential DBCC Commands

  • DBCC Commands for Verification

  • DBCC Commands to Return Process Information

  • DBCC Commands to Return Performance Monitor Statistics

  • Trace Flag Commands

  • Data Cache Commands

  • Transaction Commands

  • Other DBCC Commands

DBCC stands for Database Consistency Checker. However, over the years DBCC has grown to include commands that display configuration information, probe SQL Server's internals, and perform other commands. Therefore, it is recommended that administrators review this appendix for commands that can detect database problems and for commands that provide other types of interesting SQL ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial