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:

1

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

2

Step 3 : Select database to tune

4

Step 4: Choose indexes to Reorganise / Defrag

5

Click “Defragment selected”

image

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

Happy re-indexing

Advertisements

Leave a Reply / Comment

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

WordPress.com Logo

You are commenting using your WordPress.com 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