DBAgent Issue handling pages
Issue 3: Database Index Fragmentation above treshold (not implemented yet)
This alert is raised whenever fragmention is higher than the configured treshold:
This issue can be solved through DBAgent, manually by right-clicking the issue and choose solve... or (semi)automatically:
Indexes on tables that are permanently updated become more and more fragmented. Sometimes this is not a problem at all but often it can be a performance killer.
You could consider a Maintenance Plan or other solution that reindexes your databases.
Links that could be useful: