dbcc help ('?')
dbcc useroptions
dbcc showcontig

первый запрос возвращает перечень секций DBCC:

checkalloc
checkcatalog
checkconstraints
checkdb
checkfilegroup
checkident
checktable
cleantable
concurrencyviolation
dbreindex
dbrepair
dropcleanbuffers
free
freeproccache
help
indexdefrag
inputbuffer
memusage
newalloc
opentran
outputbuffer
perfmon
pintable
proccache
show_statistics
showcontig
shrinkdatabase
shrinkdb
shrinkfile
sqlperf
textall
textalloc
traceoff
traceon
tracestatus
unpintable
updateusage
useroptions
DBCC execution completed. If DBCC printed error messages, contact your system administrator.


Второй - конфигурацию раздела USEROPTIONS

textsize		64512	
language		us_english	
dateformat		mdy
datefirst		7
quoted_identifier	SET
arithabort		SET
ansi_null_dflt_on	SET
ansi_defaults		SET
ansi_warnings		SET
ansi_padding		SET
ansi_nulls		SET
concat_null_yields_null	SET

Третий - конфигурацию раздела showcontig

DBCC SHOWCONTIG scanning 'sysobjects' table...
Table: 'sysobjects' (1); index ID: 1, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 3390.0
- Avg. Page Density (full).....................: 58.12%
DBCC SHOWCONTIG scanning 'sysindexes' table...
Table: 'sysindexes' (2); index ID: 1, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 4
- Extents Scanned..............................: 4
- Extent Switches..............................: 3
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 25.00% [1:4]
- Logical Scan Fragmentation ..................: 75.00%
- Extent Scan Fragmentation ...................: 75.00%
- Avg. Bytes Free per Page.....................: 4170.0
- Avg. Page Density (full).....................: 48.48%
DBCC SHOWCONTIG scanning 'syscolumns' table...
Table: 'syscolumns' (3); index ID: 1, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 21
- Extents Scanned..............................: 9
- Extent Switches..............................: 9
- Avg. Pages per Extent........................: 2.3
- Scan Density [Best Count:Actual Count].......: 30.00% [3:10]
- Logical Scan Fragmentation ..................: 19.05%
- Extent Scan Fragmentation ...................: 66.67%
- Avg. Bytes Free per Page.....................: 3750.6
- Avg. Page Density (full).....................: 53.66%
DBCC SHOWCONTIG scanning 'systypes' table...
Table: 'systypes' (4); index ID: 1, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 100.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 6712.0
- Avg. Page Density (full).....................: 17.07%
DBCC SHOWCONTIG scanning 'syscomments' table...
Table: 'syscomments' (6); index ID: 1, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 14
- Extents Scanned..............................: 5
- Extent Switches..............................: 5
- Avg. Pages per Extent........................: 2.8
- Scan Density [Best Count:Actual Count].......: 33.33% [2:6]
- Logical Scan Fragmentation ..................: 21.43%
- Extent Scan Fragmentation ...................: 40.00%
- Avg. Bytes Free per Page.....................: 2852.4
- Avg. Page Density (full).....................: 64.76%
DBCC SHOWCONTIG scanning 'sysfiles1' table...
Table: 'sysfiles1' (8); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 6508.0
- Avg. Page Density (full).....................: 19.59%
DBCC SHOWCONTIG scanning 'syspermissions' table...
Table: 'syspermissions' (9); index ID: 1, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7700.0
- Avg. Page Density (full).....................: 4.87%
DBCC SHOWCONTIG scanning 'sysusers' table...
Table: 'sysusers' (10); index ID: 1, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 100.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7198.0
- Avg. Page Density (full).....................: 11.07%
DBCC SHOWCONTIG scanning 'sysdepends' table...
Table: 'sysdepends' (12); index ID: 1, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 62.0
- Avg. Page Density (full).....................: 99.23%
DBCC SHOWCONTIG scanning 'sysfilegroups' table...
Table: 'sysfilegroups' (96); index ID: 1, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 100.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 8058.0
- Avg. Page Density (full).....................: 0.44%
DBCC SHOWCONTIG scanning 'sy_b' table...
Table: 'sy_b' (389576426); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 8051.0
- Avg. Page Density (full).....................: 0.53%
DBCC SHOWCONTIG scanning 'sy_c' table...
Table: 'sy_c' (405576483); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 4
- Extents Scanned..............................: 3
- Extent Switches..............................: 2
- Avg. Pages per Extent........................: 1.3
- Scan Density [Best Count:Actual Count].......: 33.33% [1:3]
- Extent Scan Fragmentation ...................: 33.33%
- Avg. Bytes Free per Page.....................: 2675.0
- Avg. Page Density (full).....................: 66.95%
DBCC SHOWCONTIG scanning 'sy_d' table...
Table: 'sy_d' (421576540); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 5518.0
- Avg. Page Density (full).....................: 31.83%
DBCC SHOWCONTIG scanning 'sy_e' table...
Table: 'sy_e' (437576597); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7805.0
- Avg. Page Density (full).....................: 3.57%
DBCC SHOWCONTIG scanning 'sy_f' table...
Table: 'sy_f' (453576654); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 4850.0
- Avg. Page Density (full).....................: 40.08%
DBCC SHOWCONTIG scanning 'sy_h' table...
Table: 'sy_h' (485576768); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 12
- Extents Scanned..............................: 3
- Extent Switches..............................: 2
- Avg. Pages per Extent........................: 4.0
- Scan Density [Best Count:Actual Count].......: 66.67% [2:3]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 909.3
- Avg. Page Density (full).....................: 88.77%
DBCC SHOWCONTIG scanning 'sy_i' table...
Table: 'sy_i' (501576825); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 5350.0
- Avg. Page Density (full).....................: 33.90%
DBCC SHOWCONTIG scanning 'pl_a' table...
Table: 'pl_a' (517576882); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7571.0
- Avg. Page Density (full).....................: 6.46%
DBCC SHOWCONTIG scanning 'pl_b' table...
Table: 'pl_b' (533576939); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 4149.0
- Avg. Page Density (full).....................: 48.74%
DBCC SHOWCONTIG scanning 'pl_c' table...
Table: 'pl_c' (549576996); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 12
- Extents Scanned..............................: 3
- Extent Switches..............................: 2
- Avg. Pages per Extent........................: 4.0
- Scan Density [Best Count:Actual Count].......: 66.67% [2:3]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 641.0
- Avg. Page Density (full).....................: 92.08%
DBCC SHOWCONTIG scanning 'pl_d1' table...
Table: 'pl_d1' (565577053); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 6050.0
- Avg. Page Density (full).....................: 25.25%
DBCC SHOWCONTIG scanning 'pl_d2' table...
Table: 'pl_d2' (581577110); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 148
- Extents Scanned..............................: 20
- Extent Switches..............................: 19
- Avg. Pages per Extent........................: 7.4
- Scan Density [Best Count:Actual Count].......: 95.00% [19:20]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 270.9
- Avg. Page Density (full).....................: 96.65%
DBCC SHOWCONTIG scanning 'pl_d3' table...
Table: 'pl_d3' (597577167); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 21
- Extents Scanned..............................: 4
- Extent Switches..............................: 3
- Avg. Pages per Extent........................: 5.3
- Scan Density [Best Count:Actual Count].......: 75.00% [3:4]
- Extent Scan Fragmentation ...................: 25.00%
- Avg. Bytes Free per Page.....................: 583.1
- Avg. Page Density (full).....................: 92.80%
DBCC SHOWCONTIG scanning 'pl_d4' table...
Table: 'pl_d4' (613577224); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 16
- Extents Scanned..............................: 3
- Extent Switches..............................: 2
- Avg. Pages per Extent........................: 5.3
- Scan Density [Best Count:Actual Count].......: 66.67% [2:3]
- Extent Scan Fragmentation ...................: 33.33%
- Avg. Bytes Free per Page.....................: 331.6
- Avg. Page Density (full).....................: 95.90%
DBCC SHOWCONTIG scanning 'pl_d5' table...
Table: 'pl_d5' (629577281); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 100
- Extents Scanned..............................: 14
- Extent Switches..............................: 13
- Avg. Pages per Extent........................: 7.1
- Scan Density [Best Count:Actual Count].......: 92.86% [13:14]
- Extent Scan Fragmentation ...................: 7.14%
- Avg. Bytes Free per Page.....................: 344.7
- Avg. Page Density (full).....................: 95.74%
DBCC SHOWCONTIG scanning 'pl_e' table...
Table: 'pl_e' (661577395); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 678.0
- Avg. Page Density (full).....................: 91.62%
DBCC SHOWCONTIG scanning 'pl_f' table...
Table: 'pl_f' (677577452); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 7
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 3.5
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 1256.0
- Avg. Page Density (full).....................: 84.48%
DBCC SHOWCONTIG scanning 'pl_g' table...
Table: 'pl_g' (693577509); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 194
- Extents Scanned..............................: 26
- Extent Switches..............................: 25
- Avg. Pages per Extent........................: 7.5
- Scan Density [Best Count:Actual Count].......: 96.15% [25:26]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 410.6
- Avg. Page Density (full).....................: 94.93%
DBCC SHOWCONTIG scanning 'pl_h' table...
Table: 'pl_h' (709577566); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 2.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 3216.5
- Avg. Page Density (full).....................: 60.26%
DBCC SHOWCONTIG scanning 'pl_j' table...
Table: 'pl_j' (741577680); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 4
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 2.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 2074.3
- Avg. Page Density (full).....................: 74.37%
DBCC SHOWCONTIG scanning 'pl_y' table...
Table: 'pl_y' (757577737); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7479.0
- Avg. Page Density (full).....................: 7.60%
DBCC SHOWCONTIG scanning 'pl_z' table...
Table: 'pl_z' (773577794); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7093.0
- Avg. Page Density (full).....................: 12.37%
DBCC SHOWCONTIG scanning 'dc_a' table...
Table: 'dc_a' (789577851); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 4
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 2.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 478.0
- Avg. Page Density (full).....................: 94.09%
DBCC SHOWCONTIG scanning 'dc_b' table...
Table: 'dc_b' (805577908); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 3495.0
- Avg. Page Density (full).....................: 56.82%
DBCC SHOWCONTIG scanning 'dc_c' table...
Table: 'dc_c' (821577965); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 19
- Extents Scanned..............................: 4
- Extent Switches..............................: 3
- Avg. Pages per Extent........................: 4.8
- Scan Density [Best Count:Actual Count].......: 75.00% [3:4]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 602.3
- Avg. Page Density (full).....................: 92.56%
DBCC SHOWCONTIG scanning 'dc_d' table...
Table: 'dc_d' (837578022); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 2.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 2149.0
- Avg. Page Density (full).....................: 73.45%
DBCC SHOWCONTIG scanning 'dc_e' table...
Table: 'dc_e' (853578079); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7801.0
- Avg. Page Density (full).....................: 3.62%
DBCC SHOWCONTIG scanning 'dc_f' table...
Table: 'dc_f' (869578136); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 6966.0
- Avg. Page Density (full).....................: 13.94%
DBCC SHOWCONTIG scanning 'dc_g' table...
Table: 'dc_g' (885578193); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 4
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 4.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 1929.5
- Avg. Page Density (full).....................: 76.16%
DBCC SHOWCONTIG scanning 'kk_a' table...
Table: 'kk_a' (901578250); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 6
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 6.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 365.3
- Avg. Page Density (full).....................: 95.49%
DBCC SHOWCONTIG scanning 'kk_b' table...
Table: 'kk_b' (917578307); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7773.0
- Avg. Page Density (full).....................: 3.97%
DBCC SHOWCONTIG scanning 'kk_old' table...
Table: 'kk_old' (933578364); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 5500.0
- Avg. Page Density (full).....................: 32.05%
DBCC SHOWCONTIG scanning 'zw_a' table...
Table: 'zw_a' (949578421); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 2.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 3354.0
- Avg. Page Density (full).....................: 58.56%
DBCC SHOWCONTIG scanning 'zw_b' table...
Table: 'zw_b' (965578478); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 5
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 2.5
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 273.6
- Avg. Page Density (full).....................: 96.62%
DBCC SHOWCONTIG scanning 'zw_c' table...
Table: 'zw_c' (981578535); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 2430.0
- Avg. Page Density (full).....................: 69.98%
DBCC SHOWCONTIG scanning 'zw_d' table...
Table: 'zw_d' (997578592); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 2513.5
- Avg. Page Density (full).....................: 68.95%
DBCC SHOWCONTIG scanning 'zw_dc_a' table...
Table: 'zw_dc_a' (1013578649); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 4
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 4.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 478.0
- Avg. Page Density (full).....................: 94.09%
DBCC SHOWCONTIG scanning 'zw_e' table...
Table: 'zw_e' (1029578706); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7921.0
- Avg. Page Density (full).....................: 2.14%
DBCC SHOWCONTIG scanning 'zw_f' table...
Table: 'zw_f' (1045578763); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 3453.0
- Avg. Page Density (full).....................: 57.34%
DBCC SHOWCONTIG scanning 'zw_g' table...
Table: 'zw_g' (1061578820); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 2084.0
- Avg. Page Density (full).....................: 74.25%
DBCC SHOWCONTIG scanning 'zw_h' table...
Table: 'zw_h' (1077578877); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 2.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 4031.5
- Avg. Page Density (full).....................: 50.19%
DBCC SHOWCONTIG scanning 'zw_i' table...
Table: 'zw_i' (1093578934); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7548.0
- Avg. Page Density (full).....................: 6.75%
DBCC SHOWCONTIG scanning 'zw_j' table...
Table: 'zw_j' (1109578991); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 6448.0
- Avg. Page Density (full).....................: 20.34%
DBCC SHOWCONTIG scanning 'zw_k' table...
Table: 'zw_k' (1125579048); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 4624.0
- Avg. Page Density (full).....................: 42.87%
DBCC SHOWCONTIG scanning 'zw_kk_a' table...
Table: 'zw_kk_a' (1141579105); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 6
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 6.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 365.3
- Avg. Page Density (full).....................: 95.49%
DBCC SHOWCONTIG scanning 'st_a' table...
Table: 'st_a' (1173579219); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 3722.0
- Avg. Page Density (full).....................: 54.02%
DBCC SHOWCONTIG scanning 'st_b' table...
Table: 'st_b' (1189579276); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 3
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 3.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 2458.0
- Avg. Page Density (full).....................: 69.63%
DBCC SHOWCONTIG scanning 'st_c' table...
Table: 'st_c' (1205579333); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 3
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.5
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 1378.7
- Avg. Page Density (full).....................: 82.97%
DBCC SHOWCONTIG scanning 'st_e' table...
Table: 'st_e' (1237579447); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 2.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 2880.0
- Avg. Page Density (full).....................: 64.42%
DBCC SHOWCONTIG scanning 'st_f' table...
Table: 'st_f' (1253579504); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 8
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 4.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 590.8
- Avg. Page Density (full).....................: 92.70%
DBCC SHOWCONTIG scanning 'st_g' table...
Table: 'st_g' (1269579561); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7246.0
- Avg. Page Density (full).....................: 10.48%
DBCC SHOWCONTIG scanning 'st_h' table...
Table: 'st_h' (1285579618); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7715.0
- Avg. Page Density (full).....................: 4.68%
DBCC SHOWCONTIG scanning 'st_i' table...
Table: 'st_i' (1301579675); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 6676.0
- Avg. Page Density (full).....................: 17.52%
DBCC SHOWCONTIG scanning 'st_j' table...
Table: 'st_j' (1317579732); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 6316.0
- Avg. Page Density (full).....................: 21.97%
DBCC SHOWCONTIG scanning 'st_k' table...
Table: 'st_k' (1333579789); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 2164.0
- Avg. Page Density (full).....................: 73.26%
DBCC SHOWCONTIG scanning 'st_kk_a' table...
Table: 'st_kk_a' (1349579846); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 6
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 3.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 365.3
- Avg. Page Density (full).....................: 95.49%
DBCC SHOWCONTIG scanning 'st_pl_b' table...
Table: 'st_pl_b' (1381579960); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 4149.0
- Avg. Page Density (full).....................: 48.74%
DBCC SHOWCONTIG scanning 'st_pl_d2' table...
Table: 'st_pl_d2' (1397580017); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 148
- Extents Scanned..............................: 20
- Extent Switches..............................: 19
- Avg. Pages per Extent........................: 7.4
- Scan Density [Best Count:Actual Count].......: 95.00% [19:20]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 270.9
- Avg. Page Density (full).....................: 96.65%
DBCC SHOWCONTIG scanning 'st_pl_d3' table...
Table: 'st_pl_d3' (1413580074); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 20
- Extents Scanned..............................: 4
- Extent Switches..............................: 3
- Avg. Pages per Extent........................: 5.0
- Scan Density [Best Count:Actual Count].......: 75.00% [3:4]
- Extent Scan Fragmentation ...................: 25.00%
- Avg. Bytes Free per Page.....................: 207.5
- Avg. Page Density (full).....................: 97.44%
DBCC SHOWCONTIG scanning 'st_pl_d4' table...
Table: 'st_pl_d4' (1429580131); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 16
- Extents Scanned..............................: 3
- Extent Switches..............................: 2
- Avg. Pages per Extent........................: 5.3
- Scan Density [Best Count:Actual Count].......: 66.67% [2:3]
- Extent Scan Fragmentation ...................: 33.33%
- Avg. Bytes Free per Page.....................: 331.6
- Avg. Page Density (full).....................: 95.90%
DBCC SHOWCONTIG scanning 'st_zw_a' table...
Table: 'st_zw_a' (1445580188); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 3354.0
- Avg. Page Density (full).....................: 58.56%
DBCC SHOWCONTIG scanning 'st_zw_b' table...
Table: 'st_zw_b' (1461580245); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 5
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 5.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 273.6
- Avg. Page Density (full).....................: 96.62%
DBCC SHOWCONTIG scanning 'st_zw_d' table...
Table: 'st_zw_d' (1477580302); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 2.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 2513.5
- Avg. Page Density (full).....................: 68.95%
DBCC SHOWCONTIG scanning 'st_zw_g' table...
Table: 'st_zw_g' (1493580359); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 2084.0
- Avg. Page Density (full).....................: 74.25%
DBCC SHOWCONTIG scanning 'st_zw_h' table...
Table: 'st_zw_h' (1509580416); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 2.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 4031.5
- Avg. Page Density (full).....................: 50.19%
DBCC SHOWCONTIG scanning 'st_zw_i' table...
Table: 'st_zw_i' (1525580473); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 7548.0
- Avg. Page Density (full).....................: 6.75%
DBCC SHOWCONTIG scanning 'st_zw_j' table...
Table: 'st_zw_j' (1541580530); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 6448.0
- Avg. Page Density (full).....................: 20.34%
DBCC SHOWCONTIG scanning 'sy_a' table...
Table: 'sy_a' (1977058079); index ID: 0, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 2
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 2.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 4397.0
- Avg. Page Density (full).....................: 45.68%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.