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 on a specific time frame, filtered by server, database, and minimum page count. - Resources Reclaimed Over Time
Shows the number of pages reclaimed on a specific time frame, filtered by server and minimum page count. - Top 10 Fragmented Clustered Indexes
Shows a list of the top 10 clustered indexes with the greatest amount of fragmentation, filtered by server and minimum page count. - Top 10 Fragmented Indexes
Shows a list of the top 10 indexes with the greatest amount of fragmentation, filtered by server and minimum page count. - 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 to run the Report. Some options require you to establish a time frame. Click Run Report. You can also save the Report to a file or print it.