SELECT

database_id, object_name(object_id), object_id, index_id, partition_number, index_type_desc,

alloc_unit_type_desc, index_depth,

index_level, avg_fragmentation_in_percent, fragment_count, avg_fragment_size_in_pages, page_count,

avg_page_space_used_in_percent, record_count, ghost_record_count, version_ghost_record_count, min_record_size_in_bytes,

max_record_size_in_bytes, avg_record_size_in_bytes, forwarded_record_count

FROM

sys.dm_db_index_physical_stats

( 5, NULL, NULL, NULL, 'DETAILED' )

where object_name(object_id) = 'TableName'

Try this , if avg_fragmentation_in_percent is more than 30 then it is index fragmentation.