How to check sql server fragmentation

In sql server database heavily index fragmented reduce the performance of query response. Below query to help you identify the details of fragmentation.

select
OBJECT_NAME(stats.object_id) as [Object_Name],
idx.name as [Index_Name] ,
stats.avg_fragmentation_in_percent,
stats.avg_page_space_used_in_percent
from
(select OBJECT_ID, index_id, avg_fragmentation_in_percent, avg_page_space_used_in_percent
from sys.dm_db_index_physical_stats (DB_ID('NewEcater'),null,null,null,'DETAILED')
where index_id<>0) as stats
join sys.indexes idx
on idx.object_id=stats.object_id
and idx.index_id = stats.index_id

Index has "avg_fragmentation_in_percent" is greater then 10 its indicate is this index is highly fragmented and internal fragmentation value goes below 70