List of all segments and the objects on them. Use a worksheet like that in the following example:
Database Name |
DB Options Set |
Size (Mb) |
Segments Names |
Device Name |
Size (Mb) |
|---|---|---|---|---|---|
master |
none |
700 |
default.system.log |
master |
3 |
master |
none |
500 |
default.system.log |
master |
2 |
master |
none |
300 |
default.system.log |
master |
1 |
model |
none |
200 |
default.system.log |
master |
2 |
tempdb |
select into/bulkcopy |
200 |
default.system.log |
master |
2 |
TRD |
none |
10000 |
system, trd_seg1 |
TRD_dev1 |
10020 |
TRD |
none |
5000 |
system, trd_seg1, trd_seg2 |
TRD_dev2 |
5020 |
TRD |
none |
1000 |
log |
TRD_log |
1020 |
CIS |
none |
4000 |
system, cis_seg1 |
CIS_dev1 |
4020 |
CIS |
none |
400 |
log |
CIS_log |
420 |
