I tried to query the fragmentation stats on that table.

using

SELECT

a.index_id,

name,

avg_fragmentation_in_percent

FROM sys.dm_db_index_physical_stats (DB_ID(' DB '),OBJECT_ID(' Table'A' '),NULL, NULL, NULL) AS a

JOIN sys.indexes AS b ON

a.object_id = b.object_id AND

a.index_id = b.index_id;

but the query is taking tooo long.....

I checked activity monitor. and it has IX locks on that table and the wait time is 2955150046.

Is there any other place where I can look for some information.