Analyze, manage, and fix database index fragmentation
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.
$155 per user
Perpetual license without Support & Upgrades
$132 per user
$124 per user
For 20 or more users,contact us for a personalized quote.
0800 169 7433 email@example.com
Select your server and choose to scan and fix fragmentation on a specific database, all User databases, or all System databases.
You can also see the total time taken to complete the fragmentation scan.
See the suggested action, the reason for fragmentation, and the priority level for a fix.
If you use SQL Server Enterprise, you can also rebuild your indexes online.
Export the results of the fragmentation analysis as a CSV file for reporting and analyzing fragmentation over time.
You can specify what thresholds to report on for index fragmentation and size.
Just configure the option to 'sort in tempdb' and set the common timeout duration.
Start rebuilding or reorganizing selected indexes with a single click.
SQL Index Manager generates T-SQL scripts for use in SQL Server jobs to rebuild or reorganize your indexes.
See which indexes SQL Index Manager has rebuilt or reorganized in real time.
Get started with SQL Index Manager
Download a 14-day trial of SQL Index Manager
Download free trial
If you'd like any help, or have a question about our tools or purchasing options, just get in touch.