Versions Compared

Key

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

The To Do tab of the SQL Defrag Manager Console lists the indexes and partitions that require your attention based on automated policies. When you create policies, you specify threshold levels and automated responses for these fragmentation levels. Then, when SQL Defrag Manager performs a scheduled analysis, it can create To Do items for each analyzed index based on your policies.

...

To display the To Do view, click the To Do tab of the SQL Defrag Manager Console.

...

Select the item, and then click Auto Fix near the top of the window. Auto Fix performs either an analysis or defragmentation based on the recommended action. To analyze the object again, select the To Do item for that object, and then click Analyze.

To sort the activities by a column value, click the heading of that column. You can also group activities by a column value by dragging that column heading to the gray bar just above the column headings.

You can remove an action by selecting the item, and then clicking Clear near the top of the window.

...