Automatic Workspace Expansion

The sp_dbcc_updateconfig. . automatic workspace expansion option indicates whether checkstorage automatically resizes the workspace, if necessary.

At the beginning of a checkstorage run, the size of the workspace is validated. If more space is needed, and automatic workspace expansion is enabled, checkstorage automatically expands the workspace if adequate space is available on the respective segments. If more space is needed, and automatic workspace expansion is not enabled, checkstorage exits and prints an informative message.

A value of 1 (the default value) enables automatic workspace expansion. A value of 0 disables automatic workspace expansion. See the Reference Manual: Procedures.