• No, neither definition is correct.

    Typically:

    Internal fragmentation: space free on pages within the index. Shown by avg_page_space_used_in_percent in sys.dm_db_index_physical_stats.

    External fragmentation: pages out of order within the index (logical order doesn't match physical). Shown by avg_fragmentation_in_percent in sys.dm_db_index_physical_stats.

    Rather don't use the terms 'internal fragmentation' and 'external fragmentation' as they have no precise definition and everyone means something different.

    Logical fragmentation - pages out of order

    Low page density - space free on pages.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass