Does anyone know the easiest was to reduce the fragmentation of table indexes? This is the Orion database. Thanks in advance for your help.
Here's a job that I use on a scheduled basis that does the trick.
I suggest using the SQL Management Studio to create a Database Maintenance Plan.
.
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
