nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Orion SQL Database Maintenance

edavis1

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%.

Find more posts tagged with

database_administration

sql

Accepted answers

All comments

neomatrix1217

SolarWinds Knowledge Base :: Critical index fragmentation detected during database maintenance

edavis1

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?

neomatrix1217

It will run when Solarwinds DB Maintenance runs which should be nightly.

pratikmehta003

HI,

Would like to know if u face any issues after u enable it. Do let us know...

edavis1

It didn't defrag anything. The DB Maintenance just finished and the fragmentation is still the same.

neomatrix1217

Sorry was out visiting the Oracle in that ghetto housing place she lives in. Can run DB Maintenance and watch it let me know if you see it saying Defragmenting in the status bar.

edavis1

Another thing I noticed. New tables pop up with IX_InterfaceID field name and completely fragmented. That just does not seem right.

edavis1

No issues. This solved the fragmentation issue.

GoldTipu

For more details please find the details below

Indexes with fragmentation over 90% found during DB maintenance.