ApexSQL Defrag is described as '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'. There are three alternatives to ApexSQL Defrag for Windows and SQL Server Management Studio. The best alternative is dbForge Index Manager for SQL Server. Other great apps like ApexSQL Defrag are SQL Defrag Manager (Paid) and SQL Index Manager (Paid).
SSMS add-in for analyzing the status of SQL indexes and fixing issues with index fragmentation. The tool allows you to quickly collect index fragmentation statistics and detect databases that require maintenance.
- Automate identification of index fragmentation "hot spots" - Schedule index defragmentation jobs - Avoid database contention with system resource pre-checks - Reduce page splits with index fill factor settings control - Centrally manage, report and notify...
SQL Index Manager lets you quickly and easily find out the status of your indexes and discover which databases need maintenance. You can do maintenance through the UI, or generate a T-SQL script to run in SQL Server Management Studio.