12.1. DBCC validation overview
Table 12.1 shows the full set of DBCC commands by category. Note that there are a number of undocumented commands not found in this list, such as DBCC PAGE, which we'll cover later in the chapter.
| DBCC category | DBCC statement |
|---|---|
| Informational | DBCC INPUTBUFFER |
| DBCC SHOWCONTIG | |
| DBCC OPENTRAN | |
| DBCC SQLPERF | |
| DBCC OUTPUTBUFFER | |
| DBCC TRACESTATUS | |
| DBCC PROCCACHE | |
| DBCC USEROPTIONS | |
| DBCC SHOW_STATISTICS | |
| Validation | DBCC CHECKALLOC |
| DBCC CHECKFILEGROUP | |
| DBCC CHECKCATALOG | |
| DBCC CHECKIDENT | |
| DBCC CHECKDB | |
| Maintenance | DBCC CLEANTABLE |
| DBCC INDEXDEFRAG | |
| DBCC DBREINDEX | |
| DBCC SHRINKDATABASE | |
| DBCC DROPCLEANBUFFERS | |
| DBCC SHRINKFILE | |
| DBCC FREEPROCCACHE | |
| DBCC UPDATEUSAGE | |
| Miscellaneous | DBCC DLLNAME |
| DBCC HELP | |
| DBCC TRACEON | |
| DBCC ... |
Get SQL Server 2008 Administration in Action 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.
