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.
| Features | ||
|---|---|---|
| Detect index fragmentation: get a full report on indexes across your databases, including severity of fragmentation and the reasons for it. | ||
| View inter-object and inter-database dependencies | ||
| Fix fragmentation: choose which indexes to fix based on fragmentation severity – SQL Index Manager will perform the operation for you. | ||
| Reorganize or rebuild: set which action to take, based on customizable rebuild and reorganization thresholds, and rebuild indexes online with SQL Server Enterprise Edition. | ||
| Analyze over time: export the results of your analysis to track and report on fragmentation. | ||
| Generate scripts: automatically generate T-SQL scripts to fix fragmentation. |
For Demos & Free Trials, Email us at info@redgate.sqlmaestros.com or
call us at +91 7829999042, +91 7829999044
91 7829999042 91 7829999044