Page History

...

You can select from the following list of reports:

All Registered Objects

Shows all registered objects in SQL Defrag Manager (servers, databases, tables, indexes, and partitions), whether they are scheduled for automated analysis or defragmentation.

Index Counts

Shows index counts by server, database, and table registered with SQL Defrag Manager.

Page Density Change Over Time

Shows page density changes as a result of index and partition operations over time, filtered by server, database, and minimum page count.

Resources Reclaimed Over Time

Shows the number of pages reclaimed over time using SQL Defrag Manager for each server, database, index, and partition.

Top 10 Fragmented Clustered Indexes

Shows a list of the top 10 clustered indexes with the greatest amount of fragmentation.

Top 10 Fragmented Indexes

Shows a list of the top 10 indexes with the greatest amount of fragmentation.

Top 10 Largest Databases

Shows a list of the top 10 largest databases ordered by the sum of the last analyzed index page counts.

Top 10 Largest Indexes

Shows a list of the top 10 largest indexes ordered by the last analyzed index page counts.

Top 10 Largest Tables

Shows a list of the top 10 largest tables ordered by the sum of the last analyzed index page counts.

...

Need more help? Search the Idera IDERA Customer Support Portal