首页 > 代码库 > 怎样检查fragmentation
怎样检查fragmentation
可以运行下面SQL语句:
SELECT dbschemas.[name] AS ‘Schema‘, dbtables.[name] AS ‘Table‘, dbindexes.[name] AS ‘Index‘, indexstats.index_type_desc, indexstats.avg_fragmentation_in_percent, indexstats.page_countFROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS indexstatsINNER JOIN sys.tables dbtables ON (dbtables.[object_id] = indexstats.[object_id])INNER JOIN sys.schemas dbschemas ON (dbtables.[schema_id] = dbschemas.[schema_id])INNER JOIN sys.indexes AS dbindexes ON (dbindexes.[object_id] = indexstats.[object_id]AND indexstats.index_id = dbindexes.index_id)WHERE indexstats.database_id = DB_ID()ORDER BY indexstats.avg_fragmentation_in_percent DESC
参考运行后这个avg_fragmentation_in_percent值,肯定是越小越好:
怎样检查fragmentation
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。