DBCC 命令参考

最新推荐文章于 2025-06-25 09:07:08 发布

John-Sun

最新推荐文章于 2025-06-25 09:07:08 发布

阅读量636

点赞数

分类专栏： MS SQL Server 200x学习笔记文章标签： database table statistics file

MS SQL Server 200x学习笔记专栏收录该内容

4 篇文章

订阅专栏

本文提供了DBCC命令的快速参考指南，涵盖了数据库检查、修复、性能监控等关键操作的用法，帮助数据库管理员高效地管理和维护数据库。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

快速参考

下表列举了常用的一些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