Has anyone written or seen an SQL query that can automatically defragment all the tables? I found that a ton of my Orion DB have over 90% fragmentation and more than half of the tables are over 75%.
SolarWinds Knowledge Base :: Critical index fragmentation detected during database maintenance
Thanks Neo. You are the ONE. The oracle has seen it. One more quick question. When enabled, how often does the system run defrag on itself?
It will run when Solarwinds DB Maintenance runs which should be nightly.
HI,
Would like to know if u face any issues after u enable it. Do let us know...
It didn't defrag anything. The DB Maintenance just finished and the fragmentation is still the same.
No issues. This solved the fragmentation issue.
For more details please find the details below
Indexes with fragmentation over 90% found during DB maintenance.
