Once you have configured SQL Defrag Manager and assigned policies, you can run reports to compile and display the information available. You can access these reports by clicking the Reports tab.
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.
Select a Server from the drop-down list to run the Report. Some options require you establish a time frame. Click Run Report. You can also save the Report to a file or print it.