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.
Regards
Durai Nagarajan