• 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 ?