SQL Server 2008 index fragmentation

,

As a rule of thumb if the fragments are higher than 30 then you should be looking at re-indexing (REORGANIZE). Simply run the script to see if any of your fulltext indexes require any action.

SELECT OBJECT_NAME([table_id]) AS TableName, COUNT([fragment_id]) AS Fragments
FROM sys.fulltext_index_fragments
GROUP BY  OBJECT_NAME([table_id])
HAVING COUNT([fragment_id]) >=30

Rate

1.33 (3)

Share

Share

Rate

1.33 (3)