This tool 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 SSMS.
- 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
- Index rebuild with compression options
- Export of scan results into Excel, CSV, HTML and text files
- Support for any editions of SQL Server 2008+ and Azure
- And a lot of other improvements :)
You can download .zip file with the latest build of the master branch from Google Disk
- Improvements in command-line automation
- Collecting missing indexes
- Statistics maintenance
This switch is used to specify connection string.
This switch is used to specify databases to manage indexes in.
This switch is used to specify connection timeout in seconds. Overrides value specified in the connection string.
This switch is used to specify command execution timeout in seconds.
This switch is used to rebuild indexes with online option.
This switch is used to ignore any heaps during maintenance.
This switch is used to ignore any columnstore indexes during maintenance.
This switch is used to ignore any b-tree indexes during maintenance.
Configure the max degree of parallelism during maintenance.
Specifies reorganize the fragmentation threshold in %. Overrides default option (15%).
Specifies rebuild the fragmentation threshold in %. Overrides default option (30%).
This switch is used to specify the minimum index size in MB. Overrides global option (8 MB).
This switch is used to specify the predescribe index size in MB. Overrides global option (256 MB).
This switch is used to specify the maximun index size in MB. Overrides global option (8 GB).