Alter gear SQL index management

Update 06 April 2010: A new version has been released which saves the connection strings

After 3 hours, and a few other gruelling hours of trying to the get UI working Alter gear Sql index manager is now Alive.

Here is how to run it:

Step 1: Start the application:

Step 2 (optional) : select the Filter (Average fragmentation %)

Step 3 : Select database to tune

Step 4: Choose indexes to Reorganise / Defrag

Click “Defragment selected”

Defrag calls Reorganise, and Rebuild the Rebuild method on the index.

Happy re-indexing