Page History
The SQL defrag manager 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 for analysis, specify the type of analysis you want SQL defrag manager Defrag Manager to perform, and then click Finish.
...
To display the Analyze Fragmentation window, click Analyze on the Fragmentation Explorer tab of the SQL defrag manager Defrag Manager Console.
Selecting the instances and databases to analyze
The SQL Servers and Databases field lists all the registered instances and databases. When you select an instance, SQL defrag manager SQL Defrag Manager selects all the databases in that instance. You can manually select specific databases to analyze tables and indexes in those individual databases.
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 managerDefrag Manager. To register an instance with SQL defrag managerDefrag Manager, click Register on the Fragmentation Explorer tab of the SQL defrag manager Defrag Manager Console.
Difference between fast and thorough analysis
Fast analysis provides base-level analysis information, including statistics about logical order fragmentation. Logical order fragmentation occurs when the physical order of pages does not match the logical order of the pages. A fast analysis runs five to eight times quicker than a thorough analysis because SQL defrag manager Defrag Manager does not scan the leaf pages of an index. Therefore, SQL defrag manager Defrag Manager does not gather page density information during a fast analysis. You can perform a fast analysis on a database that is in use, because it consumes less time and resources than a thorough analysis.
...
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 Defrag Manager to analyze databases on a regular schedule, such as daily or weekly. Since an analysis can use system resources needed for other common database processes, you may want to schedule this analysis during periods of low database activity or demand.
...
When an activity is running, SQL defrag manager 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.
...