SCOM
Deployment
Requirements
Unpack the Spotlight Management Pack for SCOM
Configure the Spotlight Management Pack for SCOM
Workflow for Spotlight alarms
SCOM Console views of Spotlight
Snooze and acknowledge Spotlight alarms
Launch the Spotlight Client from the SCOM Console
Troubleshooting
Additional Resources
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
- Open the SQL Server | Databases Drilldown | Fragmented Indexes.
- Select the index to defragment and click Fragmented Indexes | Generate defragmentation script.
-
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. |