Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a SQL 2008 Standard server on full mirror (safety). I reorganize all indexes weekly. I am looking into rebuilding a few indexes to improve performance. I ran DBCC SHOWCONTIG on my largest, most accessed table and got the following results.

DBCC SHOWCONTIG scanning 'MYTABLE' table...
Table: 'MYTABLE' (12345678); index ID: 1, database ID: 7
TABLE level scan performed.
- Pages Scanned................................: 738663
- Extents Scanned..............................: 92661
- Extent Switches..............................: 92720
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.58% [92333:92721]
- Logical Scan Fragmentation ..................: 0.35%
- Extent Scan Fragmentation ...................: 41.58%
- Avg. Bytes Free per Page.....................: 467.9
- Avg. Page Density (full).....................: 94.22%

Would rebuilding the index make sense on this table? Would there be any benefits to doing so?

share|improve this question

migrated from serverfault.com Feb 13 at 10:17

This question came from our site for professional system and network administrators.

    
Please switch to using sys.dm_db_index_physical_stats -- DBCC SHOWCONTIG has been deprecated for quite some time now. –  Jon Seigel Feb 13 at 14:26
    
ola.hallengren.com/… -- Ola Hallegren has the best script to do the job for you. I second on Jon's comment! –  DenisT Feb 13 at 17:05
    
Jon- Thanks, I'll try that. –  xweb Feb 14 at 3:26
    
Denis- Ill take a look. –  xweb Feb 14 at 3:26

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.