dbcc 中文意思是什麼
dbcc
解釋
數據庫一致性檢測-
E. using dbcc showcontig and dbcc indexdefrag to defragment the indexes in a database
E .使用dbcc showcontig和dbcc indexdefrag對數據庫中的索引進行碎片整理 -
Must be specified to run dbcc maintenance commands with
運行dbcc維護命令時,必須指定此參數。 -
If any errors are reported by dbcc checkdb, we recommend restoring the database from the database backup instead of running repair with one of the repair options
如果dbcc checkdb報告了任何錯誤,建議從數據庫備份還原數據庫,而不運行具有一個repair選項的repair 。 -
After the dbcc catalog command finishes, a message is written to the sql server error log
Dbcc catalog命令完成後,會將一條消息寫入sql server錯誤日誌。 -
All dbcc command parameters can accept both unicode and dbcs literals
所有dbcc命令參數都可以接受unicode和dbcs文字。 -
Dbcc checkdb does not examine disabled indexes
Dbcc checkdb不檢查禁用的索引。 -
Noindex does not affect system tables because dbcc checkfilegroup always checks all system table indexes
Noindex不影響系統表,因為dbcc checkdb總是對所有系統表索引進行檢查。 -
Unlike dbcc showcontig, the fragmentation calculation algorithms in both cases consider storage that spans multiple files and, therefore, are accurate
與dbcc showcontig不同,這兩種情況下的碎片計算演算法都會考慮跨越多個文件的存儲,因而結果是精確的。 -
Number of times the dbcc statement moved from one extent to another while the statement traversed the pages of the table or index
遍歷表或索引的頁時, dbcc語句從一個區移動到另一個區的次數。 -
If one occurs, run dbcc checkdb to determine the extent of the damage
如果發生這種錯誤,請運行dbcc checkdb以確定損壞的程度。 -
An unknown error occurred that terminated the dbcc command
出現終止了dbcc命令的未知錯誤。 -
If dbcc printed error messages, contact your system administrator
出現終止了dbcc命令的未知錯誤。 -
If a dbcc check is run, the check marks any error - free pages as repaired
如果運行dbcc檢查,則該檢查會將所有未出錯頁標記為已修復( -
Use dbcc updateusage to synchronize space - usage counters
使用dbcc updateusage同步空間使用計數器。 -
Many dbcc commands can produce output in tabular form by using the with tableresults option
許多dbcc命令都可以使用with tableresults選項以表格形式輸出。 -
Causes the dbcc command to obtain an exclusive database lock
使dbcc命令獲取排他數據庫鎖。 -
Dbcc commands take input parameters and return values
Dbcc命令使用輸入參數並返回值。 -
Dbcc checkcatalog performs various consistency checks between system metadata tables
Dbcc checkcatalog在系統元數據表之間執行各種一致性檢查。 -
Dbcc checktable performs consistency checks on a single table or indexed view and all its nonclustered and xml indexes, unless the noindex option is specified. to perform dbcc checktable on every table in the database, use
除非指定noindex選項,否則, dbcc checktable將對單個表或索引視圖及其所有非聚集索引以及xml索引執行物理一致性檢查。 -
Dbcc results for master. table sys. sysrowsetcolumns object id 4
這指示導致dbcc命令終止的元數據損壞。
分享友人