Skip to content

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

License

Notifications You must be signed in to change notification settings

ViRuSTriNiTy/sql-index-console

 
 

Repository files navigation

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

About

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

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • C# 95.3%
  • Inno Setup 4.7%