brianpursley/sql-index-console

A utility for detecting SQL Server index fragmentation and rebuilding/reorganizing indexes to remove fragmentation

sql-index-console

SQL Index Console is a utility for detecting SQL Server index fragmentation and rebuilding/reorganizing indexes to remove fragmentation.

Setup

SqlIndexConsoleSetup-1.0.3.exe

Features

Detect Index Fragmentation

• Get a detailed list of indexes, including type, size, amount of fragmentation, and other attributes.
• Detect index and table fragmentation, including clustered index fragmentation, nonclustered index fragmentation, and heap fragmentation.
• Get automatic recommendations for whether to rebuild or reorganize each index based on thresholds you can configure.
• Sort and filter the report to find the indexes you are interested in.

Fix Fragmented Indexes

• Use the default recommendations or manually override the recommendation for any index by checking the Rebuild or Reorganize checkbox.
• Preview the selected actions before executing them.
• Defrag the indexes with the click of a button in SQL Index Console, or generate a T-SQL script that can be run in SQL Server Management Studio.

Analyze

• Export the detailed index list to Excel, CSV file, or text file so you can analyze fragmentation over time.

Screenshots