Changes the size of the specified workspace to a specified value, and initializes the workspace.
sp_dbcc_alterws dbname, wsname, "wssize[K|M]"
is the name of the database in which the workspace resides. Specify either dbccdb and dbccalt.
specifies the name of the workspace to alter.
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.
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
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
See the System Administration Guide for more information on the scan and text workspaces, and the dbccalt database.
Only a System Administrator or the Database Owner can run sp_dbcc_alterws.
Commands dbcc
dbcc stored procedures sp_dbcc_createws, sp_dbcc_evaluatedb
System procedures sp_plan_dbccdb, sp_helpdb
