1、问题描述

2、解决方案

• 选择数据中心（要选择数据中心对应的那个数据库）

• 脚本粘贴到查询框中

SELECT i.name AS indexname, o.name AS tablename, s.name AS schemaname, f.index_type_desc AS indextype, f.avg_page_space_used_in_percent AS indexdensity, f.avg_fragmentation_in_percent AS indexfragmentation, f.page_count AS pages FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'SAMPLED') f INNER JOIN sys.objects o ON o.object_id = f.object_id INNER JOIN sys.schemas s ON o.schema_id = s.schema_id INNER JOIN sys.indexes i ON f.object_id = i.object_id AND f.index_id = i.index_id WHERE page_count > 50 AND f.index_id > 0 ORDER BY o.name, i.index_id

• 执行查询

执行的结果可以导入excel或csv中发出来

3、补充

需要将脚本一起复制到查询框中执行，脚本的内容也可以参考附件脚本

SQL Server数据库查询索引碎片率的脚本.rar