Chapter 4: dbcc Stored Procedures

sp_dbcc_createws

Creates a workspace of the specified type and size on the specified segment and database.

sp_dbcc_createws dbname, segname, [wsname], wstype, "wssize[K|M]"

dbname: is the name of the database in which the workspace is to be created. Values are dbccdb and dbccalt.

wsname: is the name of the workspace. If the value is null, sp_dbcc_createws generates the name scan_ws_nnnnnn for the scan workspace and text_ws_nnnnnn for the text workspace, where nnnnnn is a unique 6-digit number.

wstype: specifies the type of workspace to be create. Values are scan and text.

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

Creates a 10MB scan workspace named scan_ws_pubs2 on the scanseg segment in dbccdb:

sp_dbcc_createws dbccdb, scanseg, scan_ws_pubs2, scan, "10M"

Creates a 14MB scan workspace named text_ws_000001 on the textseg segment in dbccdb:

sp_dbcc_createws dbccdb, textseg, text, "14M"

sp_dbcc_createws creates a workspace with the specified name and size and initializes it.
Before you create a workspace, create the segment with sp_addsegment.
Before you create a workspace, make sure you have configured a buffer pool of at least 16K, to achieve maximum performance.
When you create a workspace, make sure to add a 5% overhead on the space needed on the device because of large page allocation scheme used when creating the workspace.
Use sp_plan_dbccdb to determine size estimates.
After creating a workspace, run sp_dbcc_updateconfig to record the new configuration information in dbcc_config.
Each workspace must have a unique name.
To delete a workspace, in dbccdb issue:
```
drop table workspace_name
```

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