sp_dbcc_createws

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

Syntax

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.
segname – is the name of the segment for the workspace.
wsname – is the name of the workspace. If the value is null, sp_dbcc_createws generates the name scan_wsnnnnnn for the scan workspace and text_wsnnnnnn 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.

Example 1 – Creates a 10MB scan workspace named scan_wspubs2 on the scanseg segment in dbccdb:
```
sp_dbcc_createws dbccdb, scanseg, scan_wspubs2, scan, "10M"
```
Example 2 – Creates a 14MB scan workspace named text_ws000001 on the textseg segment in dbccdb:
```
sp_dbcc_createws dbccdb, textseg, text, "14M"
```

There are additional considerations when using sp_dbcc_createws:

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 percent 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
```

The permission checks for sp_dbcc_createws differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be the database owner of `dbccdb` (or `dbccalt`).
Disabled	With granular permissions disabled, you must be the database owner of `dbccdb` (or `dbccalt`), or have sa_role to run sp_dbcc_createws.