Online Documentation for SQL Administrator for SQL Server

Setting check options


Use this step of the wizard to options for the check database operation. The set options displayed depends on the selected checks to perform on the third step.

 

Check Database Wizard - Setting check options

 

 

Check parameters

 

!CheckBox No intensive checks of nonclustered indexes

This argument (NOINDEX) specifies that intensive checks of non-clustered indexes for user tables should not be performed; therefore, the overall execution time is decreased.

Note: This option is available only if !RadioButton No repair data has been selected on the previous step.

 

!CheckBox Extended index logical checks (intensive operation)

This argument (EXTENDED_LOGICAL_CHECKS) performs logical consistency checks on an indexed view, XML indexes, and spatial indexes, where present if the compatibility level is 100 (SQL Server 2008) or higher.

 

!CheckBox Allow take exclusive table locks to execute faster

This argument (TABLOCK) causes DBCC CHECKTABLE to obtain a shared table lock instead of using an internal database snapshot. TABLOCK will cause DBCC CHECKTABLE to run faster on a table under heavy load, but decreases the concurrency available on the table while DBCC CHECKTABLE is running.

 

!CheckBox Check the integrity of physical structures only

This argument (PHYSICAL_ONLY) limits the checking to the integrity of the physical structure of the page, record headers and the physical structure of B-trees. Designed to provide a small overhead check of the physical consistency of the table, this check can also detect torn pages, and common hardware failures that can compromise data.

Note: This option is available only if !RadioButton No repair data has been selected on the previous step.

 

!CheckBox Check for valid or out-of-range column values

This argument (DATA_PURITY) causes DBCC CHECKTABLE to check the table for column values that are not valid or out-of-range. For example, DBCC CHECKTABLE detects columns with date and time values that are larger than or less than the acceptable range for the datetime data type; or decimal or approximate-numeric data type columns with scale or precision values that are not valid.

Note: If PHYSICAL_ONLY is specified, column-integrity checks are not performed.

 

 

Check output options

 

!CheckBox Show all information messages

If this option is selected then an unlimited number of information messages is displayed.

 

!CheckBox Show only the first 200 errors

If this option is selected then only first 200 errors will be displayed. By default all error messages are displayed.

 

 

Click the Next button to proceed to the Checking database step of the wizard.