DBCC 命令参考

快速参考

下表列举了常用的一些DBCC 命令的使用方法：

DBCC CHECKALLOC 
( 'database_name'
[, NOINDEX
|
{ REPAIR_ALLOW_DATA_LOSS
| REPAIR_FAST
| REPAIR_REBUILD
}]
) [WITH {ALL_ERRORMSGS | NO_INFOMSGS}]

DBCC CHECKCATALOG [(database_name)] [WITH NO_INFOMSGS]

DBCC CHECKTABLE
    (    'table_name'
            [,     NOINDEX
                | index_id
                |    {    REPAIR_ALLOW_DATA_LOSS
                        | REPAIR_FAST
                        | REPAIR_REBUILD
                    }]
    ) [WITH {ALL_ERRORMSGS | NO_INFOMSGS}]

DBCC CHECKDB
    (    'database_name'
            [,     NOINDEX
                |     {    REPAIR_ALLOW_DATA_LOSS
                        | REPAIR_FAST
                        | REPAIR_REBUILD
                    }]
    ) [WITH {ALL_ERRORMSGS | NO_INFOMSGS}]

DBCC CHECKFILEGROUP
    (    [{'filegroup' | filegroup_id}] [, NOINDEX]
    ) [WITH {ALL_ERRORMSGS | NO_INFOMSGS}]

DBCC CHECKIDENT [(table_name)] [, { NORESEED | {RESEED
    [,new_reseed_value] } } ] )

DBCC DBREINDEX (['database.owner.table_name' [, index_name
    [, fillfactor ]]])[WITH NO_INFOMSGS]
DBCC dllname (FREE)

DBCC INPUTBUFFER (spid)

DBCC OPENTRAN ({database_name} | {database_id}) [WITH TABLERESULTS]
    [,NO_INFOMSGS]

DBCC OUTPUTBUFFER (spid)

DBCC PERFMON

DBCC PINTABLE
    (database_id, table_id)

DBCC SHOW_STATISTICS
    (table_name, index_name)

DBCC SHOWCONTIG
    (table_id, [index_id])

DBCC SHRINKDATABASE (database_name [, target_percent]  [, {NOTRUNCATE
    | TRUNCATEONLY} ])

DBCC SHRINKFILE
    (    {file_name | file_id }
            {    [, target_size]
            |    [, {EMPTYFILE | NOTRUNCATE | TRUNCATEONLY}]
            }
    )

DBCC SQLPERF (LOGSPACE)

DBCC TRACEOFF (trace# [,...N])

DBCC TRACEON (trace# [,...N])

DBCC TRACESTATUS (trace# [, trace#...])

DBCC UNPINTABLE (database_id, table_id)
DBCC UPDATEUSAGE
    (    {'database_name' | 0}
            [, 'table_name' [, index_id]
            ]
    )    [    WITH [COUNT_ROWS] [, NO_INFOMSGS ]
        ]

DBCC USEROPTIONS