Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

Index Fragmentation Alarm

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 the alarm is raised

  1. Open the SQL Server | Databases Drilldown | Fragmented Indexes.
  2. Select the index to defragment and click Fragmented Indexes | Generate defragmentation script.
  3. Use SQL Server Management Studio to schedule a job to run this script during a quiet period.

TIP: Choose a quiet time to run this script. Execution of this script could put significant load on the SQL Server.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating