Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
duhaas
Constraint Violating Yak Guru
310 Posts |
 Posted - 2006-10-30 : 17:12:36
|
| Just want to verify im ready everything right from my results, it would appear that most tables are optimized???DBCC SHOWCONTIG scanning 'colAccountPositions' table...Table: 'colAccountPositions' (624057309); index ID: 1, database ID: 7TABLE level scan performed.- Pages Scanned................................: 142078- Extents Scanned..............................: 17808- Extent Switches..............................: 18082- Avg. Pages per Extent........................: 8.0- Scan Density [Best Count:Actual Count].......: 98.21% [17760:18083]- Logical Scan Fragmentation ..................: 0.15%- Extent Scan Fragmentation ...................: 32.30%- Avg. Bytes Free per Page.....................: 318.8- Avg. Page Density (full).....................: 96.06%DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC SHOWCONTIG scanning 'colAccountPositionsArchive' table...Table: 'colAccountPositionsArchive' (220579874); index ID: 0, database ID: 7TABLE level scan performed.- Pages Scanned................................: 12938- Extents Scanned..............................: 1619- Extent Switches..............................: 1618- Avg. Pages per Extent........................: 8.0- Scan Density [Best Count:Actual Count].......: 99.94% [1618:1619]- Extent Scan Fragmentation ...................: 0.43%- Avg. Bytes Free per Page.....................: 396.3- Avg. Page Density (full).....................: 95.10%DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC SHOWCONTIG scanning 'tblNSCCPositionHistory' table...Table: 'tblNSCCPositionHistory' (89767377); index ID: 1, database ID: 7TABLE level scan performed.- Pages Scanned................................: 25432- Extents Scanned..............................: 3189- Extent Switches..............................: 3236- Avg. Pages per Extent........................: 8.0- Scan Density [Best Count:Actual Count].......: 98.21% [3179:3237]- Logical Scan Fragmentation ..................: 0.21%- Extent Scan Fragmentation ...................: 20.41%- Avg. Bytes Free per Page.....................: 396.9- Avg. Page Density (full).....................: 95.10%DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC SHOWCONTIG scanning '_archive_tblNSCCPositionHistory' table...Table: '_archive_tblNSCCPositionHistory' (999010640); index ID: 0, database ID: 7TABLE level scan performed.- Pages Scanned................................: 23272- Extents Scanned..............................: 2911- Extent Switches..............................: 2910- Avg. Pages per Extent........................: 8.0- Scan Density [Best Count:Actual Count].......: 99.93% [2909:2911]- Extent Scan Fragmentation ...................: 1.65%- Avg. Bytes Free per Page.....................: 312.2- Avg. Page Density (full).....................: 96.14%DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC SHOWCONTIG scanning 'colPrices' table...Table: 'colPrices' (1431012179); index ID: 1, database ID: 7TABLE level scan performed.- Pages Scanned................................: 3606- Extents Scanned..............................: 466- Extent Switches..............................: 490- Avg. Pages per Extent........................: 7.7- Scan Density [Best Count:Actual Count].......: 91.85% [451:491]- Logical Scan Fragmentation ..................: 0.92%- Extent Scan Fragmentation ...................: 22.75%- Avg. Bytes Free per Page.....................: 1013.9- Avg. Page Density (full).....................: 87.47%DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC SHOWCONTIG scanning 'colHeadcount' table...Table: 'colHeadcount' (944058449); index ID: 1, database ID: 7TABLE level scan performed.- Pages Scanned................................: 2387- Extents Scanned..............................: 302- Extent Switches..............................: 317- Avg. Pages per Extent........................: 7.9- Scan Density [Best Count:Actual Count].......: 94.03% [299:318]- Logical Scan Fragmentation ..................: 0.80%- Extent Scan Fragmentation ...................: 30.79%- Avg. Bytes Free per Page.....................: 11.4- Avg. Page Density (full).....................: 99.86%DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC SHOWCONTIG scanning '_archive_tblControlNo' table...Table: '_archive_tblControlNo' (871010184); index ID: 0, database ID: 7TABLE level scan performed.- Pages Scanned................................: 849- Extents Scanned..............................: 108- Extent Switches..............................: 107- Avg. Pages per Extent........................: 7.9- Scan Density [Best Count:Actual Count].......: 99.07% [107:108]- Extent Scan Fragmentation ...................: 7.41%- Avg. Bytes Free per Page.....................: 381.3- Avg. Page Density (full).....................: 95.29%DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC SHOWCONTIG scanning '_archive_tblTransHistory' table...Table: '_archive_tblTransHistory' (1031010754); index ID: 0, database ID: 7TABLE level scan performed.- Pages Scanned................................: 3535- Extents Scanned..............................: 444- Extent Switches..............................: 443- Avg. Pages per Extent........................: 8.0- Scan Density [Best Count:Actual Count].......: 99.55% [442:444]- Extent Scan Fragmentation ...................: 1.13%- Avg. Bytes Free per Page.....................: 321.7- Avg. Page Density (full).....................: 96.03%DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC SHOWCONTIG scanning '_archive_tblUniqueControlNo' table...Table: '_archive_tblUniqueControlNo' (1047010811); index ID: 0, database ID: 7TABLE level scan performed.- Pages Scanned................................: 782- Extents Scanned..............................: 99- Extent Switches..............................: 98- Avg. Pages per Extent........................: 7.9- Scan Density [Best Count:Actual Count].......: 98.99% [98:99]- Extent Scan Fragmentation ...................: 3.03%- Avg. Bytes Free per Page.....................: 557.8- Avg. Page Density (full).....................: 93.11%DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC SHOWCONTIG scanning 'tblControlNo' table...Table: 'tblControlNo' (1357247890); index ID: 1, database ID: 7TABLE level scan performed.- Pages Scanned................................: 780- Extents Scanned..............................: 111- Extent Switches..............................: 117- Avg. Pages per Extent........................: 7.0- Scan Density [Best Count:Actual Count].......: 83.05% [98:118]- Logical Scan Fragmentation ..................: 1.54%- Extent Scan Fragmentation ...................: 62.16%- Avg. Bytes Free per Page.....................: 457.0- Avg. Page Density (full).....................: 94.35%DBCC execution completed. If DBCC printed error messages, contact your system administrator. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-31 : 02:17:11
|
| "it would appear that most tables are optimized???"Just a suggestion:REINDEX them all, run SHOWCONTIG again, and compare the output?(The tables don't look too big, so I reckon this won't have to big an impact on Log or CPU - but be preapred for that!)Kristen |
 |
|
|
|
|
|
|
|
Performance DBCC SHOWCONTIG Top10