find index fragmentation

SELECT ps.database_id, ps.OBJECT_ID,
ps.index_id, b.name,
ps.avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS ps
INNER JOIN sys.indexes AS b ON ps.OBJECT_ID = b.OBJECT_ID
AND ps.index_id = b.index_id
WHERE ps.database_id = DB_ID()
ORDER BY ps.OBJECT_ID
GO
---o is heap
---1 is Clustured index
----2 Non clustured index


based on fragmentation you can either rebuild or re organize indexes , please do it after hours as it is an resource intensive operation and might block users who uses Tables containing indexes


Thanks