Versions Compared

Key

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

...

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 does not scan the leaf pages of an index. Therefore, SQL 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 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.

...

2-Steps analysis

The Fragmentation Explorer tab allows you to easily analyze and defragment individual objects, such as specific tables and indexes. You can view the most recent analysis results before taking any additional actiona specific instance, database, table, or index. Right-click the object you want to analyze to open the contextual menu and select the type of analysis 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 Cancel Activity in the lower left-hand corner of the status bar. To cancel an activity, click Cancel Activity while the activity runs.

...