striker-baba (4/23/2010)
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.
Can you run that during off-hours ?
If you're doing a lot of inserts, maybe you should just rebuild indexes anyway ?