https://blogs.msdn.microsoft.com/dynamics_latam/2010/09/27/cmo-conocer-el-porcentaje-de-fragmentacin-para-los-ndices-en-tablas-de-microsoft-dynamics-ax/
SELECT t4.name AS [schema_name]
, t3.name AS TABLE_NAME
, t2.name AS index_name
, t1.object_id
, t1.index_id
, t1.partition_number
, t1.index_type_desc
, t1.avg_fragmentation_in_percent
, t1.avg_fragment_size_in_pages
, t1.page_count
FROM sys.dm_db_index_physical_stats(db_id(),NULL,NULL,NULL,'LIMITED' ) t1
INNER JOIN sys.objects t3 ON (t1.object_id = t3.object_id)
INNER JOIN sys.schemas t4 ON (t3.schema_id = t4.schema_id)
INNER JOIN sys.indexes t2 ON (t1.object_id = t2.object_id AND t1.index_id = t2.index_id )
WHERE index_type_desc <> 'HEAP'
ORDER BY t4.name,t3.name,t2.name,partition_number