Database Options

Enabled Options

select into/bulkcopy/pllsort

Placement

Device Name	Size	Usage
data_dev1	1580	data only
data_dev2	1000	data only
data_dev3	2000	data only
data_dev4	2000	data only
data_dev6	1000	data only
data_dev7	500	data only
log_dev1	500	log only
log_dev3	100	log only
log_dev1	50	log only

Database Usage

Data	4556.04 (56.39 %)
Indexes	2011.92 (24.90 %)
Unused	67.17 (0.83 %)
Unreserved	1444.87 (17.88 %)

Log Usage

Log Used	0.11 (0.02 %)
Log Unused	649.89 (99.98 %)

DDL

USE master
go
CREATE DATABASE icsa
    ON data_dev1=1580,   
    data_dev2=1000,   
    data_dev3=2000,   
    data_dev4=2000
    LOG ON log_dev1=500
go
ALTER DATABASE icsa 
    ON data_dev6=1000
go
ALTER DATABASE icsa 
    ON data_dev7=500
go
ALTER DATABASE icsa 
    LOG ON log_dev3=100
go
ALTER DATABASE icsa 
    LOG ON log_dev1=50
go
USE master
go
EXEC sp_dboption 'icsa','select into/bulkcopy/pllsort',true
go
USE icsa
go
CHECKPOINT
go
USE icsa
go
EXEC sp_changedbowner 'isopma'
go
EXEC sp_addsegment 'default','icsa','data_dev1'
go
EXEC sp_extendsegment 'default','icsa','data_dev2'
go
EXEC sp_extendsegment 'default','icsa','data_dev3'
go
EXEC sp_extendsegment 'default','icsa','data_dev4'
go
EXEC sp_extendsegment 'default','icsa','data_dev6'
go
EXEC sp_extendsegment 'default','icsa','data_dev7'
go
EXEC sp_addsegment 'logsegment','icsa','log_dev1'
go
EXEC sp_extendsegment 'logsegment','icsa','log_dev3'
go
EXEC sp_addthreshold 'icsa','logsegment',19592,'sp_thresholdaction'
go
EXEC sp_addthreshold 'icsa','logsegment',45192,'sp_thresholdaction'
go
EXEC sp_addsegment 'slewsegment','icsa','data_dev1'
go
EXEC sp_extendsegment 'slewsegment','icsa','data_dev2'
go
EXEC sp_extendsegment 'slewsegment','icsa','data_dev3'
go
EXEC sp_extendsegment 'slewsegment','icsa','data_dev4'
go
EXEC sp_extendsegment 'slewsegment','icsa','data_dev6'
go
EXEC sp_addsegment 'system','icsa','data_dev1'
go
EXEC sp_extendsegment 'system','icsa','data_dev2'
go
EXEC sp_extendsegment 'system','icsa','data_dev3'
go
EXEC sp_extendsegment 'system','icsa','data_dev4'
go
EXEC sp_extendsegment 'system','icsa','data_dev6'
go
EXEC sp_extendsegment 'system','icsa','data_dev7'
go