I'm trying to defrag indexes. When I run SHOWCONTIG I get the following
for these tables:



Table: 'arc_in_att' (757577737); index ID: 0, database ID: 7

TABLE level scan performed.

- Pages Scanned................................: 4204

- Extents Scanned..............................: 567

- Extent Switches..............................: 566

- Avg. Pages per Extent........................: 7.4

- Scan Density [Best Count:Actual Count].......: 92.77% [526:567]

- Extent Scan Fragmentation ...................: 99.82%

- Avg. Bytes Free per Page.....................: 1499.9

- Avg. Page Density (full).....................: 81.47%

DBCC SHOWCONTIG scanning 'arc_in_bodies' table...

Table: 'arc_in_bodies' (773577794); index ID: 0, database ID: 7

TABLE level scan performed.

- Pages Scanned................................: 5575

- Extents Scanned..............................: 728

- Extent Switches..............................: 727

- Avg. Pages per Extent........................: 7.7

- Scan Density [Best Count:Actual Count].......: 95.74% [697:728]

- Extent Scan Fragmentation ...................: 99.86%

- Avg. Bytes Free per Page.....................: 446.4

- Avg. Page Density (full).....................: 94.48%

DBCC SHOWCONTIG scanning 'arc_out' table...

Table: 'arc_out' (789577851); index ID: 0, database ID: 7

TABLE level scan performed.

- Pages Scanned................................: 69342

- Extents Scanned..............................: 8681

- Extent Switches..............................: 8680

- Avg. Pages per Extent........................: 8.0

- Scan Density [Best Count:Actual Count].......: 99.85% [8668:8681]

- Extent Scan Fragmentation ...................: 67.31%

- Avg. Bytes Free per Page.....................: 2920.5

- Avg. Page Density (full).....................: 63.92%





After running the following statement: DBCC
DBREINDEX('arc_in_att','',70) or for the other 2 tables, no changes
take place.



I run SHOWCONTIG after running DBREINDEX and nothing seems to change.
Am I missing a parameter, or doing something incorrectly?



Thanks!






This e-mail and any documents transmitted with it are the property of Corinthian Mortgage, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender. E-mail is electronically archived and recorded, and is subject to review, monitoring and/or disclosure to company employee's other than the intended recipient.

This e-mail may contain data that is confidential, proprietary or "non-public personal information", as that term is defined in the Gramm-Leach-Bliley Act (collectively, "Confidential Information"). The Confidential Information is disclosed conditioned upon your agreement that you will treat it confidentially and in accordance with applicable law, ensure that such data isn't used or disclosed except for the limited purpose for which its being provided and will notify and cooperate with us regarding any requested or unauthorized disclosure or use of any Confidential Information. By accepting and reviewing the Confidential Information you agree to indemnify us against any losses or expenses, including attorneys fees that we may incur as a result of any unauthorized use or disclosure of this data due to your acts or omissions.

Corinthian Mortgage does not endorse the use of unsolicited e-mail. If you believe this e-mail was sent to you in error or you do not with to receive these types of e-mail, please notify our Information Technology department by forwarding this message to [Email address protected] or go to http://www.corinthianmortgage.com/content/optout.asp?email=[Email address protected]




MS Sql Server LazyDBA home page