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
    
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
add comment

migrated from serverfault.com Feb 13 at 10:17

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

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.