Page History
The Recent Activity tab of the SQL defrag manager Defrag Manager Console displays the analysis and defragmentation tasks SQL defrag manager Defrag Manager has performed. You can view the improvements accomplished during each defragmentation task.
SQL defrag manager SQL Defrag Manager supports partitioned indexes similarly to non-partitioned indexes. A row exists for each partition having a recent activity. SQL defrag manager SQL Defrag Manager displays the total number of partitions analyzed or defragmented in thePartition column. Select that row and SQL defrag manager Defrag Manager displays additional information about the partitions in the Details section of the window.
...
To view the details of an activity, click the plus sign icon to the left of the activity. SQL defrag manager Defrag Manager lists expanded information about each index or partition. You can select an item in the list and then review the information displayed in the Details section of the window.
...
| Item | Description |
|---|---|
| Action | Specifies whether the action was an analysis or a defragmentation, and the type of analysis (fast or thorough), or the type of defragmentation (reorganize or rebuild) that occurred. |
| Job Type | Identifies whether the action was scheduled or run manually. |
| Process Time | Identifies the amount of time required for the action to finish. |
| Result | Specifies the final result of the action, such as whether it was completed. |
| Error Detail | Identifies any error that occurred during the action. |
| SQL Server Name | Specifies the name of the instance that contains the database. |
| Database Name | Specifies the name of the database that was analyzed or defragmented. If you select an activity for more than one database, this field identifies the total number of databases included in the recent activity. |
| Table Name | Specifies the name of the table that was analyzed or defragmented. If you select an activity for more than one table, this field identifies the total number of tables included in the recent activity. |
| Index Name | Specifies the name of the index that was analyzed or defragmented. If you select an activity for more than one index, this field identifies the total number of indexes included in the recent activity. |
| Partition Number | Specifies the number of the partition that was analyzed or defragmented. If you select an activity for more than one partition, this field identifies the total number of partitions included in the recent activity. |
When SQL defrag manager Defrag Manager finishes performing an analysis or defragmentation activity, it adds that activity to the Recent Activity tab of the SQL defrag manager Defrag Manager Console.
Grouping information
...
To save the information displayed in the Recent Activity tab, click Export near the top of the window. SQL defrag manager Defrag Manager saves the items displayed in the Recent Activity tab as a file.
To print the list of activities displayed on the Recent Activity tab, click Print near the top of the window. With this feature, you can report on the activities SQL defrag manager Defrag Manager has performed and review them to ensure you have the management approach you want.
...