22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT
OBJECT_NAME(a.object_id) AS TabName,
a.object_id AS objectid,
b.name AS IndexName,
a.index_id AS indexid,
a.partition_number AS partitionnum,
a.avg_fragmentation_in_percent AS frag
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, 'LIMITED') AS a
INNER JOIN sys.indexes AS b ON a.OBJECT_ID=b.object_id AND a.index_id=b.index_id
WHERE a.avg_fragmentation_in_percent > 10.0 AND a.index_id > 0
ORDER BY frag DESC;