Skip to content

Latest commit

 

History

History
33 lines (22 loc) · 1.88 KB

README.md

File metadata and controls

33 lines (22 loc) · 1.88 KB

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

sqlindexconsolemain

sqlindexconsolemainnoaction

sqlindexconsoleoptions

sqlindexconsolepreview

sqlindexconsolescript