DBCC SHOWCONTIG scanning 'SensorDataAVP1' table...
Table: 'SensorDataAVP1' (1842105603); index ID: 1, database ID: 7
TABLE level scan performed.
- Pages Scanned................................: 10276331
- Extents Scanned..............................: 1290358
- Extent Switches..............................: 1290495
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.54% [1284542:1290496]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 7.87%
- Avg. Bytes Free per Page.....................: 458.5
- Avg. Page Density (full).....................: 94.34%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC SHOWCONTIG scanning 'SensorData1' table...
Table: 'SensorData1' (1810105489); index ID: 1, database ID: 7
TABLE level scan performed.
- Pages Scanned................................: 2758045
- Extents Scanned..............................: 345491
- Extent Switches..............................: 345490
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.79% [344756:345491]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 12.55%
- Avg. Bytes Free per Page.....................: 666.8
- Avg. Page Density (full).....................: 91.76%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC SHOWCONTIG scanning 'Observances' table...
Table: 'Observances' (530100929); index ID: 1, database ID: 7
TABLE level scan performed.
- Pages Scanned................................: 152109
- Extents Scanned..............................: 19120
- Extent Switches..............................: 19145
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.31% [19014:19146]
- Logical Scan Fragmentation ..................: 0.01%
- Extent Scan Fragmentation ...................: 1.42%
- Avg. Bytes Free per Page.....................: 799.6
- Avg. Page Density (full).....................: 90.12%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC SHOWCONTIG scanning 'DailyAttackHistory' table...
Table: 'DailyAttackHistory' (1061578820); index ID: 1, database ID: 7
TABLE level scan performed.
- Pages Scanned................................: 9847
- Extents Scanned..............................: 1241
- Extent Switches..............................: 1249
- Avg. Pages per Extent........................: 7.9
- Scan Density [Best Count:Actual Count].......: 98.48% [1231:1250]
- Logical Scan Fragmentation ..................: 0.09%
- Extent Scan Fragmentation ...................: 0.81%
- Avg. Bytes Free per Page.....................: 796.9
- Avg. Page Density (full).....................: 90.15%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC SHOWCONTIG scanning 'NetworkInterface' table...
Table: 'NetworkInterface' (338100245); index ID: 1, database ID: 7
TABLE level scan performed.
- Pages Scanned................................: 19192
- Extents Scanned..............................: 2411
- Extent Switches..............................: 2410
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.50% [2399:2411]
- Logical Scan Fragmentation ..................: 0.02%
- Extent Scan Fragmentation ...................: 76.57%
- Avg. Bytes Free per Page.....................: 775.5
- Avg. Page Density (full).....................: 90.42%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC SHOWCONTIG scanning 'SensorDataResponse1' table...
Table: 'SensorDataResponse1' (2034106287); index ID: 1, database ID: 7
TABLE level scan performed.
- Pages Scanned................................: 8738
- Extents Scanned..............................: 1123
- Extent Switches..............................: 1123
- Avg. Pages per Extent........................: 7.8
- Scan Density [Best Count:Actual Count].......: 97.24% [1093:1124]
- Logical Scan Fragmentation ..................: 0.57%
- Extent Scan Fragmentation ...................: 65.18%
- Avg. Bytes Free per Page.....................: 283.0
- Avg. Page Density (full).....................: 96.50%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC SHOWCONTIG scanning 'MessageLog' table...
Table: 'MessageLog' (274100017); index ID: 1, database ID: 7
TABLE level scan performed.
- Pages Scanned................................: 7741
- Extents Scanned..............................: 977
- Extent Switches..............................: 993
- Avg. Pages per Extent........................: 7.9
- Scan Density [Best Count:Actual Count].......: 97.38% [968:994]
- Logical Scan Fragmentation ..................: 0.25%
- Extent Scan Fragmentation ...................: 89.46%
- Avg. Bytes Free per Page.....................: 733.9
- Avg. Page Density (full).....................: 90.93%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC SHOWCONTIG scanning 'CheckPlatforms' table...
Table: 'CheckPlatforms' (661577395); index ID: 1, database ID: 7
TABLE level scan performed.
- Pages Scanned................................: 600
- Extents Scanned..............................: 76
- Extent Switches..............................: 75
- Avg. Pages per Extent........................: 7.9
- Scan Density [Best Count:Actual Count].......: 98.68% [75:76]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 807.3
- Avg. Page Density (full).....................: 90.03%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC SHOWCONTIG scanning 'SensorDataAVP2' table...
Table: 'SensorDataAVP2' (553769030); index ID: 1, database ID: 7
TABLE level scan performed.
- Pages Scanned................................: 1607
- Extents Scanned..............................: 202
- Extent Switches..............................: 201
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.50% [201:202]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.50%
- Avg. Bytes Free per Page.....................: 747.8
- Avg. Page Density (full).....................: 90.76%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC SHOWCONTIG scanning 'CheckOSGroup' table...
Table: 'CheckOSGroup' (629577281); index ID: 1, database ID: 7
TABLE level scan performed.
- Pages Scanned................................: 448
- Extents Scanned..............................: 57
- Extent Switches..............................: 56
- Avg. Pages per Extent........................: 7.9
- Scan Density [Best Count:Actual Count].......: 98.25% [56:57]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 805.1
- Avg. Page Density (full).....................: 90.05%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Partager