SQLIndexManager
SQLIndexManager copied to clipboard
Free GUI Tool for Index Maintenance on SQL Server and Azure
SQL Index Manager
This tool lets you quickly 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 SSMS.
SQL Index Manager – CodeProject
Key Features
- An incredibly fast describe engine
- Multiple databases scanning
- Advice on rebuilding or reorganizing
- Analysis of fragmentation results
- Configurable fragmentation thresholds
- One-click maintenance
- Command-line automation
- Automatic T-SQL script generation
- Columnstore maintenance support
- Statistics maintenance
- Collecting missing indexes
- Detect duplicate indexes
- Drop or disable unused indexes
- Index rebuild with compression options
- Support for any editions of SQL Server 2008+ and Azure
- And a lot of other improvements :)
Latest Version
You can download .zip file with the latest build of the master branch from Releases
Screenshots