This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Cleaning indexes in Orion database - fragmentation percentage high

jdunne over 9 years ago

Does anyone know the easiest was to reduce the fragmentation of table indexes? This is the Orion database. Thanks in advance for your help.

Top Replies

0 mharvey over 9 years ago

Here's a job that I use on a scheduled basis that does the trick.
Cancel
Vote Up +1 Vote Down

Cancel
0 aLTeReGo over 9 years ago
I suggest using the SQL Management Studio to create a Database Maintenance Plan.

Use the Maintenance Plan Wizard
.
Cancel
Vote Up +2 Vote Down

Cancel
0 spursatx over 7 years ago in reply to mharvey

Hi mharvey,
How long did it take the SQL script to execute the 1st run? Our dbmaintenance log file highlighted the following indexes that need to be De-fragmented manually. I'm interested in how it's working for you currently and how often you usually run this. Thanks in advance!!
2016-09-21 04:52:43,175 [1] WARN SolarWinds.Data.IndexDefragmentation.IndexDefragmenter - Index IX_NodeID on table ResponseTime_Detail_20160922 has fragmentation 98.8687007199177% and should be defragmented.
2016-09-21 04:52:43,175 [1] WARN SolarWinds.Data.IndexDefragmentation.IndexDefragmenter - Index PK_Traps on table Traps has fragmentation 99.9911606116857% and should be defragmented.
2016-09-21 04:52:43,175 [1] WARN SolarWinds.Data.IndexDefragmentation.IndexDefragmenter - Index IX_TrapType on table Traps has fragmentation 99.770290964778% and should be defragmented.
2016-09-21 04:52:43,175 [1] WARN SolarWinds.Data.IndexDefragmentation.IndexDefragmenter - Index IX_InterfaceID on table InterfaceErrors_Detail_20160922 has fragmentation 91.64265129683% and should be defragmented.
2016-09-21 04:52:43,175 [1] WARN SolarWinds.Data.IndexDefragmentation.IndexDefragmenter - Index IX_InterfaceID on table InterfaceTraffic_Detail_20160922 has fragmentation 95.3029271613342% and should be defragmented.
2016-09-21 04:52:43,175 [1] WARN SolarWinds.Data.IndexDefragmentation.IndexDefragmenter - Index InterfaceTraffic_Detail_20160922 on table InterfaceTraffic_Detail_20160922 has fragmentation 91.8318794607454% and should be defragmented.
2016-09-21 04:52:43,175 [1] INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Index defragmentation completed
2016-09-21 04:52:43,175 [1] INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Database Maintenance Complete.
2016-09-21 04:52:43,175 [1] DEBUG SolarWinds.Orion.Common.SqlHelper - SQL: dbm_EndMaintenance
Cancel
Vote Up 0 Vote Down

Cancel