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.
Lynn Pettis
SSC Guru
Points: 442467
More actions
January 31, 2015 at 7:05 pm
#1774590
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.