Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Defragment and Optimization window allows you to defragment one to defragment one or more instances and databases. The SQL Servers and Databases field lists all the registered instances and databases. You can select the databases you want to defragment, and then select the type of defragmentation approach you want SQL Defrag Manager to use. SQL Defrag Manager can simply reorganize indexes for optimal performance, or defragment indexes by completely rebuilding them.

...

The Fragmentation Explorer tab allows you to analyze and defragment individual objects, such as specific tables and indexes, and then view the results.

Canceling an activity

When an activity is running, SQL Defrag Manager displays Cancel Activity in the lower left-hand corner of the status bar. To cancel an activity, click Cancel Activity while the activity runs.

 Image Added

Need more help? Search the IDERA Customer Support Portal

...