Page History

The SQL Defrag Manager Analyze Fragmentation window allows you to investigate the fragmentation levels of tables and indexes in the registered databases and instances. The SQL Servers and Databases field lists all the registered instances and databases. Select one or more database databases for analysis, specify the type of analysis you want SQL Defrag Manager to perform, and then click Finish.

Access the Analyze Fragmentation window

To display the Analyze Fragmentation window, click Analyze Analyze on the Fragmentation Explorer tab of the SQL Defrag Manager Console.

...

If the instance or database you want to analyze is not listed in the SQL Servers and Databases field, you may not have registered it with SQL Defrag Manager. To register an instance with SQL Defrag Manager, click Register on the Fragmentation Explorer tab of the SQL Defrag Manager Console.

...

Analyze an individual table or index

The Fragmentation Explorer tab allows you to analyze and defragment individual objects, such as specific tables and indexes. You can view the most recent analysis results before taking any additional action.

...

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  Cancel Activity while the activity runs.

...