这些命令可能会影响系统的性能和/或表级锁。不能保证这些命令仍将可用在任何未来的版本的SQL server。
DBCC activecursors [(spid)]
DBCC addextendedproc (function_name dll_name)
DBCC addinstance (objectname,都)
DBCC adduserobject(名字)
DBCC auditevent (eventclass eventsubclass,成功,loginname、rolename dbusername, loginid)
DBCC自动驾驶仪(类型id, dbid,衰弱的、indid页[标记])
DBCC balancefactor (variance_percent)
DBCC bufcount [(number_of_buffers)]
DBCC缓冲区({“dbname”| dbid} [, objid[、数量(printopt={0 | 1 | 2}][,脏| io | | rlock | ioerr |散列]]])
DBCC字节(startaddress、长度)
DBCC cachestats
DBCC callfulltext
DBCC checkdbts (dbid newTimestamp)]
DBCC checkprimaryfile({“文件名”}(选择={0 | 1 | 2 | 3}))
DBCC cacheprofile [({actionid} [, bucketid])
DBCC clearspacecaches (' database_name ' | database_id,‘table_name | table_id,‘index_name | index_id)
DBCC collectstats (|)
DBCC配置
DBCC cursorstats ([spid[,“清晰”]])
DBCC dbinfo [(dbname)]
DBCC dbrecover (dbname [, IgnoreErrors])
DBCC dbreindexall (db_name/db_id type_bitmap)
DBCC dbrepair (dbname, DROPDB [, NOINIT])
DBCC数据表(({“dbname”| dbid}))
DBCC debugbreak
DBCC deleteinstance (objectname,都)
DBCC des (({“dbname”| dbid} [, {“objname”| objid})))
DBCC detachdb [(dbname)]
DBCC dropextendedproc (function_name)
DBCC dropuserobject (“object_name”)
DBCC dumptrigger({‘休息’,{0 | 1}}|“显示”|{‘设置’,exception_number} |{“清楚”,exception_number})
DBCC errorlog
DBCC extentinfo [({“database_name”| dbid | 0}, {“table_name”| table_id}, {“index_name”| index_id | 1}))))
DBCC fileheader [({“dbname”| dbid}[,文件标识)
DBCC fixallocation[({“添加”|“删除”},{“页面”|“SINGLEPAGE”|“程度”|“MIXEDEXTENT”}, filenum, pagenum [、objectid indid])
DBCC冲洗(“数据”|“日志”,dbid)
DBCC flushprocindb(数据库)
DBCC freeze_io (db)
DBCC getvalue(名字)
DBCC icecapquery (dbname, stored_proc_name [# _times_to_icecap(1无限,0关闭)])
使用“dbcc icecapquery (printlist)看到SP的概要文件的列表。
使用“dbcc icecapquery (icecapall)所有SP的概要文件。
DBCC incrementinstance (objectname, countername,都值)
DBCC印第安纳州({“dbname”| dbid}, {“objname”| objid}, {indid | 0 | 1 | 2})
DBCC invalidate_textptr (textptr)
DBCC invalidate_textptr_objid (objid)
DBCC iotrace ({“dbname”| dbid | 0 | 1},{文件标识| 0},bufsize, [{numIOs | 1},{超时(秒)| 1}[printopt={0 | 1}]]])
DBCC插销(地址(“业主”)[' stackdumps '])
DBCC锁([{“DUMPTABLE”|“DUMPSTATS”|“RESETSTATS”|“希”}]| [{STALLREPORTTHESHOLD, stallthreshold}])
DBCC lockobjectschema (“object_name”)
DBCC日志([dbid [{0 | 1 | 2 | 3 | 4}, [[‘lsn’,‘[0 x] x, y: z) | (numrecs, num) | (' xdesid ', ' x: y '] |(“程度”,“x, y”】|【pageid ', ' x: y '] | (objid, {x, y}】|【logrecs,{“删”| op}…] |(“输出”,x,[“文件名”、“x”]]…]]])
DBCC loginfo [({“database_name”| dbid}))
DBCC matview({“持久化”|“ENDPERSIST”|“免费”|“使用“|”ENDUSE})
DBCC memobjlist[(内存对象)]
DBCC memorymap
DBCC memorystatus
DBCC memospy
DBCC memusage ([id |名称],[输出]的行数)