ApexSQL Defrag

ApexSQL Defrag is enterprise SQL Server tool used for analyzing, monitoring and managing SQL Server index fragmentation. The application allows detailed index fragmentat...

Paid • Proprietary
Windows

What is 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