Index Fragmentation Exceeds Acceptable Limit

This warning has been raised because the index is fragmented more than the percentage limit set in the Aireforge Studio settings. Highly fragmented indexes are less efficient and can use more storage (disk and memory) than less fragmented ones.

Depending on the fragmentation level and the edition of SQL Server, Aireforge Studio may recommend either reorganizing the index or completely rebuilding it.

Suggested Action

đź’ˇ Aireforge Advisor can automatically generate a script for this.

  1. Defragment or rebuild the index.
  2. Implement an index maintenance strategy.

How to Defrag Indexes in SQL Server

DBCC INDEXDEFRAG(WhippetWorks, 'dbo.TableName', IX_IndexName);
GO

How to Rebuild Indexes in SQL Server

ALTER INDEX IX_IndexName ON TableName
REBUILD WITH (ONLINE = ON, SORT_IN_TEMPDB = ON);

Further Reading

​DBCC INDEXDEFRAG | Microsoft Docs

​Reorganize and Rebuild Indexes | Microsoft Docs

​SQL Server Index and Statistics Maintenance | SQL Server Maintenance Solution