Norb Technologies offers the intuitive and powerful Visual Defrag [2005] for Microsoft SQL Server 2005, 2000 and 7.0 with a flexible scheduler and detailed visual reports so you can target defragmentation where it's needed most, a SQL administrator can get helpful reports and keep on top of database performance.

Using Visual Defrag in a very brief and non technical manner we could analyze and take corrective actions within minutes of the product's delivery of statistics on overall database and table fragmentation.

By the time we arrived the job had already been finished after the completion of the backup, so we could concentrate on other admin tasks. Needless to say that the file fragmentation was reduced from 99% to 23% in under an hour and the performance of the database was greatly increased. From then, we scheduled a defrag job of the same database every weekend ensuring data integrity for all our customers, internal and external.

Visual Defrag 2007 shows all values of the database you are analyzing and the best part is that this will run in Windows 2008 (Beta Test June 2007-June 2008) and SQL Server 2008 without any problems. It also works with Office 2007 Excel perfectly.