Get maintenance recommendations

Last modified: May 12, 2023

After dbForge Index Manager scans your SQL Server databases, you can sort and search the results to get a selection of indexes that require defragmentation. For every index, you get the following information:

• Index size
• Cause and percentage of fragmentation
• Maintenance priority
• Recommended actions: rebuilding or reorganization

Let’s not forget about customization. For instance, you can do the following to adjust the display of scan results:

• Set the index fragmentation threshold
• Set the minimum index size
• Choose the index rebuild method: online or offline
• Restore default options

Finally, you can export scan results to a CSV file to perform an in-depth index fragmentation analysis, or generate a report based on this information.