Ver fragmentación de indices de tablas

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