Utility for SQL server maintenance (Defragment Utility)

Dear Friends,

Database maintenance is one of the tedious task sometime if you are not well aware what to apply. So don’t worry now

Indiandotnet providing a simple utility which help you in analyzing the Indexes for  which need maintenance and for which we need to run some maintenance script.

So let me explain the utility first

when you run the utility you will get following screen.

Login_Screen

Now you need to fill SQL Server name username & password and click on login button. If the login is wrong then you will get error message else the database(s) name(s) which exists on that particular server is populated in just below drop which is select Database once you select the database for which you need to analyze the index defragment then click on analyze button.  After the button click you will find the result in below grid.

In the grid you will get index with name & table name with fragmentation details.

Indexes which  have fragmentation percentage  more then 35% shows in Red color. Indexes which have fragmentation higher then 5% and lower than 35% shows in Yellow color.

If the Row in Red color means you need to Rebuild the index and if it is in Yellow color then you need to Reorganize.

Once you select the rows  and click on Improve button then it will generate a script and you can run this directly on the server.

As the Index build  & reorganize depends on database size so you need to take care when you can run it.

You can download the application code from download.

Please feel free to give your feedback & comments.

Enjoy defragmentation 🙂

Thanks & Best Regards,

Rajat Jaiswal

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

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