Hi

I am trying to find the physical index fragmentation % in a dynamic system view. I can however only find the logical fragmentation. In "sys.dm_db_index_physical_stats", the "avg_fragmentation_in_percent" is the same as the Logical Scan Fragmentation when using "DBCC SHOWCONTIG (TableName) with all_indexes"

Is there a dynamic view where I can see the "Extent Scan Fragmentation" as shown when running "DBCC SHOWCONTIG (TableName) with all_indexes"?

Tx