Page History
The To Do tab of the SQL defrag manager 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 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 Defrag Manager Console.
How partitioned indexes are addressed in the To Do view
SQL defrag manager SQL Defrag Manager supports partitioned indexes similarly to non-partitioned indexes. A row exists for each partition that triggers an action on the To Do view. Each partition in an index is identified by a number, which SQL defrag manager SQL Defrag Manager displays in the Partition column. Select the row for the partition and SQL defrag manager Defrag Manager displays additional information about that partition in the Details section of the window.
...
The data in the Details section of the window provides complete information about the item selected in the main section of the window.
| Item | Description |
|---|---|
| Server Name | Specifies the name of the instance that contains the database. |
| Database Name | Specifies the name of the database that contains the table. |
| Table Name | Specifies the name of the table that has the identified index to defragment. |
| Index Name | Specifies the name of the index to defragment. |
| Partition Number | Specifies the number of the partition to defragment. |
| Clustered Index | Indicates whether the index is a clustered index. |
| Detected On | Identifies when the analysis that created this To Do item occurred. |
| Problem | Describes the issue identified by SQL Defrag Manager. |
| Recommendation | Provides a recommendation for how to resolve the identified fragmentation issue. |
How grouping information helps
...
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.
Need more help? Search the IDERA Customer Support Portal
...