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.
Analyze individual databases, or multiple databases at once
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.
Advice on rebuilding or reorganizing
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.
Configurable fragmentation thresholds
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.