Segments for workspaces

By dedicating segments for workspaces, you can control workspace placement and improve dbcc checkstorage performance. When you dedicate new segments for the exclusive use of workspaces, use sp_dropsegment to unmap the devices attached to these segments from the default segment.