Get maintenance recommendations

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.