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


Leave a Reply / Comment

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s