Home Forums SQL Server 2008 SQL Server 2008 - General 'sys.dm_db_index_physical_stats' giving 3 rows with different fragmentation. RE: 'sys.dm_db_index_physical_stats' giving 3 rows with different fragmentation.

  • Tac11 (2/1/2015)


    So which level is fragmented 99% according to G. Berry's script? should I be worried about above result and run rebuild index job?

    My guess, since you don't have the index_level included in your post, would be level 0 which would be the leaf level.