sp_dbcc_alterws

Description

Changes the size of the specified workspace to a specified value, and initializes the workspace.

Syntax

sp_dbcc_alterws dbname, wsname, "wssize[K|M]"

Parameters

dbname: is the name of the database in which the workspace resides. Specify either dbccdb and dbccalt.

wsname: specifies the name of the workspace to alter.

wssize: is the new size of the workspace, specified by K (kilobytes) or M (megabytes). If you do not specify K or M, wssize specifies the number of pages. Page size is platform-dependent. The minimum size for a workspace is 24 pages.

Examples

Example 1

Changes the size of the scan_ws_000001 workspace on dbccdb to 30MB:

sp_dbcc_alterws dbccdb, scan_ws_000001, "30M"

Workspace scan_ws_000001 has been altered successfully to size 30MB

Usage

sp_dbcc_alterws changes the size of the specified workspace to the specified value and initializes the workspace.

To achieve maximum performance, make sure you have configured a buffer pool of at least 16K before you alter a workspace.

Use sp_plan_dbccdb to determine size estimates before altering the workspace.
The workspace must exist before it can be altered. For information on creating workspaces, see sp_dbcc_createws.
To delete a workspace, in dbccdb issue:
```
drop table workspace_name
```

Permissions

Only a System Administrator or the Database Owner can run sp_dbcc_alterws.

See also

See the System Administration Guide for more information on the scan and text workspaces, and the dbccalt database.

Commands dbcc

dbcc stored procedures sp_dbcc_createws, sp_dbcc_evaluatedb

System procedures sp_plan_dbccdb, sp_helpdb