Versions Compared

Key

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

...

The information in the Details section of the window provides complete information about the recent activity selected in the main section of the window. 

ItemDescription
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.

A Before/After comparison between Fragmentation and Pages statistics view is available only from the expanded view of an activity (click the plus sign icon to the left of an activity) after you select an individual index.

...

You can also filter the list of activities displayed by Result, Action, and Type. 


Scroll pdf ignore

Need more help? Search the IDERA Customer Support Portal