Page History

...

Automation allows you to define a custom schedule for analyzing and potentially defragmenting databases during periods of low activity. You can also set SQL Defrag Manager to analyze databases on a regular schedule, such as daily or weekly. Because the database is unavailable while SQL Defrag Manager rebuilds one or more indexes in the database, you should run this defragmentation during periods when the database can be offline and unavailable.

Defragmenting an individual table or index

2-Steps defragmentation

The The Fragmentation Explorer tab  tab allows you to analyze and easily defragment individual objects from the navigation tree, such as specific tables and indexes, and then view the resultsa specific instance, database, table, or index, as well as the entire SQL Defrag Manager environmet. Right-click the object you want to defragment to open the contextual menu, click the Defragment all/entire... option and select the type of defragmentation you want to perform. Click here to learn more about actions you can perform from the contextual menu.

Canceling an activity

When an activity is running, SQL Defrag Manager displays  a Cancel Activity option in the lower left-hand corner of the status bar. Click the option to stop the activity from running.

...