SQLServer check fragmentation

check_fragmentation.sql

-- Find the average fragmentation percentage of all indexes  
-- in the HumanResources.Employee table.   
SELECT
　i.index_id, name
　, s.avg_fragmentation_in_percent 
　, s.avg_fragment_size_in_pages
　, s.fragment_count, s.page_count 
FROM sys.dm_db_index_physical_stats (NULL, NULL, NULL, NULL, NULL) AS s  
    JOIN sys.indexes AS i ON a.object_id = b.object_id AND a.index_id = b.index_id
where s.avg_fragmentation_in_percent > 30
order by s.avg_fragmentation_in_percent desc
;
GO