Find and Fix SQL Fragmentation

SQL Defrag Manager

SQL Defrag Manager Product Tour

Fragmentation Explorer: Analyze databases to collect updated fragmentation information, review the analysis results, and defragment the highly-fragmented areas to optimize performance and space usage.

To Do Tasks: View the indexes and partitions that require attention based on automated policies. Choose which activities to perform to defragment the objects that have severe or critical levels of fragmentation.

Automation Policies: Analyze database index fragmentation across the enterprise to find and defragment hot spots to improve performance. Use policies to automate this process and maintain databases with minimal time and effort.

Recent Activity: Display a list of the analysis and defragmentation tasks performed to view the improvements accomplished during each defragmentation task.

Fill Factor Settings: Adjust the fill factor and padding for indexes while viewing recent analysis and fragmentation results for a selected index.