Page History
Once SQL defrag manager IDERA analyzes the registered instances and databases, you can use the Fragmentation Explorer tab to view the latest analysis information. SQL defrag manager Defrag Manager displays the analysis details for the objects in the selected database object. For example, if you select a table, SQL defrag manager Defrag Manager displays the analysis details for each index on that table.
You should regularly monitor fragmentation levels on indexes and schedule SQL defrag manager Defrag Manager to analyze database fragmentation. Use the scheduled analysis to identify specific fragmentation levels before defining your policies to automatically reorganize or rebuild indexes.
...
To display the Fragmentation Explorer, click the Fragmentation Explorer tab of the SQL defrag manager Defrag Manager Console.
About the icons and fragmentation statistics
...
Low page density can cause SQL Server to read more pages than necessary when using an index, such as when performing a query. When data is initially stored on the pages, SQL Server uses the fillfactor value to determine how much data to store on each page. At this point, page density is relatively high, but the page density becomes lower as data is inserted and pages are split to make room for the additional data. SQL defrag manager Defrag Manager can reorganize or rebuild indexes to increase page density and reduce the number of reads when using the index.
...
The Show/Hide filter options allow you to refine which objects SQL defrag manager Defrag Manager displays on the Fragmentation Explorer tab. When you clear the check box for a group of objects, such as the Excluded check box, SQL defrag manager Defrag Manager does not display those objects and updates the displayed fragmentation statistics, such as Average Fragmentation and Relative Fragmentation to not include those objects.
The Criteria option defines which objects are represented by the Excluded group. If you clear the Excluded check box, SQL defrag manager Defrag Manager does not display objects that match the specified criteria.
...
When an activity is running, SQL defrag manager SQL Defrag Manager displays Cancel Activity in the lower left-hand corner of the status bar. To cancel an activity, click Cancel Activity while the activity runs.
...