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.

  • Look carefully at the output of the data, you will see that there may be multiple index levels. The function, sys.dm_db_index_physical_stats, when run with the DETAIL option shows the fragmentation level of indexes at all levels.