ApexSQL Defrag Alternatives

ApexSQL Defrag

ApexSQL Defrag is enterprise SQL Server tool used for analyzing, monitoring and managing SQL Server index fragmentation. The application allows detailed index fragmentation analysis on server, database and table level. With ApexSQL Defrag you can rebuild or reorganize fragmented indexes in real time, as well as create policies and apply them to multiple databases or servers.

Features:

- Supports Microsoft SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016 and 2017 CTP2
- Detailed index fragmentation analysis on local and remote SQL Server instances
- Rebuild and reorganize fragmented indexes
- Set fragmentation scan density
- Set the fragmentation thresholds for reorganize and rebuild jobs
- Create and manage customizable policies
- Use predefined template policies
- Scan for and delete duplicate indexes
- Find unused indexes
- Set CPU load threshold, memory load threshold, hard drive space threshold and page density threshold for defragmentation jobs
- Set the schedule for defragmentation jobs
- Set the Email notifications for succeeded/failed jobs
- Monitor all defragmentation jobs and policies from a central location
- Group the results by any column from the grid
- Filter the grid results
- Export the activities to CSV or XML
- Create fragmentation reports on index fragmentation and index memory usage
- Get the reports for specified timeframe
- Print the reports, or export them to PDF, HTML, or image file