查看索引碎片

SELECT t.name                  AS tableName,
       i.name                  AS indexName,
       ps.index_type_desc,
       ps.avg_fragmentation_in_percent,
       ps.page_count
FROM   sys.tables              AS t
       INNER JOIN sys.indexes  AS i
            ON  t.[object_id] = i.[object_id]
       CROSS APPLY sys.dm_db_index_physical_stats (DB_ID(), t.[object_id], i.index_id, DEFAULT, DEFAULT) AS ps
ORDER BY
       ps.avg_fragmentation_in_percent DESC

参考：  msdn. sys.dm_db_index_physical_stats (Transact-SQL)