The Recent Activity tab of the SQL defrag manager Console displays the analysis and defragmentation tasks SQL defrag manager has performed. You can view the improvements accomplished during each defragmentation task.
How are partitioned indexes addressed in the Recent Activity view?
SQL defrag manager supports partitioned indexes similarly to non-partitioned indexes. A row exists for each partition having a recent activity. SQL defrag manager displays the total number of partitions analyzed or defragmented in the Partition column. Select that row and SQL defrag manager displays additional information about the partitions in the Details section of the window.
How can I display details for an activity?
To view the details of an activity, click the plus sign icon to the left of the activity. SQL 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.
What do the details mean?
The information in the Details section of the window provides complete information about the recent activity selected in the main section of the window. The Fragmentation and Pages comparison statistics are available only when you click the plus sign icon to the left of an activity and select an individual index.
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. |
How do items get created on this window?
When SQL defrag manager finishes performing an analysis or defragmentation activity, it adds that activity to the Recent Activity tab of the SQL defrag manager Console.
How does grouping information help me?
You can group activities by when they occurred, the action that occurred, or by the name of the instance, database, table, index, or partition. To group the displayed activities by a column value, drag that column heading to the gray bar above the column headings.
Grouping recent activities allows you to quickly scan and evaluate your management activities. For example, you can group and view activities for a specific database, table, index, or partition, which lets you focus on the activities for that database object to make sure they are the activities you need to run.
How do I sort activities listed on this window?
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.
How do I remove an activity listed on this window?
To remove an activity listed on the Recent Activity tab, select the activity, and then click Clear. You can also select Clear All to remove all activities listed on this window.
How do I save the displayed information?
To save the information displayed in the Recent Activity tab, click Export near the top of the window. SQL defrag manager saves the items displayed in the Recent Activity tab as a file.
How do I print the list of recent activities?
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 has performed and review them to ensure you have the management approach you want.