DBCC用法（DBCC usage）.docVIP

DBCC用法（DBCC usage） DBCC usage DBCC SQL Server provides a set of console commands, very powerful, master some necessary statements, there are a lot of help to the operation of the database, so I decided to tidy up and found many similar finishing has a lot less work, classified as follows: First, the DBCC help class Command * DBCC HELP (?) Query all the DBCC commands * DBCC HELP (command) Query for the syntax instructions for the specified DBCC command * DBCC USEROPTIONS Returns the SET option for the active (settings) of the current connection Two, DBCC check validation class Command * DBCC CHECKALLOG (database name) Checks the consistency of the disk space allocation structure for the specified database * DBCC CHECKCATALOG (database name) Check the consistency between the system tables and the system tables of the specified database * DBCC CHECKCONSTAINTS (tablename) Checks the integrity of the specified constraint or all constraints on the specified table * DBCC CHECKDB Check the allocation and structure integrity of all objects in the database * DBCC CHECKFILEGROUP Checks the allocation and structure integrity of all tables in the specified file group in the current database * DBCC CHECKTABLE Checks the data, indexes, and integrity of the test, ntest, and image pages of the specified table or index view * DBCC CHECKIDENT Checks the specified current identity value * DBCC, SQLPERF (UMSSTATS), undocumented, in, BOL Can be used to check if CPU usage has reached a bottleneck One of the most critical reference data, Num runnable, indicates how many threads are waiting to run at the moment If it is greater than or equal to 2, consider CPU to reach the bottleneck Three, DBCC maintenance class Command * DBCC CLEANTABLE (db_name,table_name) Retrieve the Alter table drop column statement to delete variable length columns or text * DBCC DBREINDEX Rebuild one or more indexes of a specified database * DBCC INDEXDEFRAG Defragmentation of indexes and non clustered indexes on ta