If your indexes are fragmented it can make life difficult for end-users as the server slows down and performance levels drop. SQL Defrag Studio will analyze your indexes and show you just how healthy each index is.

The color-coding directs you immediately to problem areas where you need to focus your defrag efforts. You can see from the graphical representation where fragmention exists. This fragmentation may have caused your SQL Server to gradually slow down. It may even have ground to a halt.

Now you know where it is, you can use SQL Defrag Studio to tune-up your problem indexes and bring back your performance.

Once you've defragmented your indexes it's a good idea to update the statistics on your tables, and also recompile your stored procedures. Now that your data has been re-ordered, this will help SQL Server find it even faster when it comes to queries.

You can update all the statistics and recompile your stored procs automatically with SQL Defrag Studio. It's as simple as ticking a couple of boxes to tell SQL Defrag Studio to do these actions once the defrag job is completed.

It depends on how you use your databases, but if you've got inserts and deletes taking place on a regular basis, then you'll find you need to defrag on a regular basis. How often this is, is determined by how many changes are made to your data.

But don't worry about having to do the same work over and over again. You can quickly create scheduled jobs inside SQL Defrag Studio to defrag your indexes.

SQL Defrag Studio is unrestricted in the number of jobs you can create. Create as many as you need and then manage them with the My Defrag Jobs panel. You can see when each job last run and when it's due to be run again, helping you tailor your defrag operations to your specific needs.

Defragmenting is a disk-intensive operation which can slow down the server while the indexes are being tuned. It's best to defrag during the quietest times, usually overnight. Your users will certainly appreciate it!

Creating a new job with SQL Defrag Studio couldn't be easier. You'll find the same options for the schedule as you're used to in SQL Server's management tools.

Once your jobs are running on a regular basis, you'll find your SQL Server maintains its index performance. You'll banish those stressful support calls as a result of the server coming to a halt, simply because of index fragmentation.

Goodbye slow server, hello speed!