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:

• https://www.brentozar.com/archive/2012/08/sql-server-index-fragmentation/ (this one suggests to "stop worrying about it...")
• https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes
• https://ola.hallengren.com/ (a very comprehensive solution, for free!)

> Home >

< Back <

updated 2018-10-17 9:40 PM