The Index Fragmentation alarm is raised when the largest Index file on the SQL Server is more than 5% fragmented. It is a good idea to defragment large index files that are more than 5% fragmented.
Note: Spotlight only checks large index files, that is Index files that have over 1000 pages.
When this alarm is current,
Use SQL Server Management Studio to schedule a job to run this script during a quiet period.
Note: Choose a quiet time to run this script. Execution of this script could put significant load on the SQL Server.
