SQL Defrag Manager is a unique SQL Server index defragmentation solution that automates the time-consuming process of finding fragmented indexes based on parameters that you define within a policy for the targeted database. It gives you the flexibility to run the defragmentation utility immediately or during off-peak hours, all through an easy-to-use graphical user interface. There are no manual scripts required. SQL Defrag Manager improves server performance by ensuring that indexes are defragmented, which helps SQL server applications run faster and frees DBAs to perform other tasks.
Use the following checklist to get started using SQL Defrag Manager.
|Follow these steps ...|
|Register the SQL Server instances you want to defragment.|
|Analyze your SQL Servers to find fragmented hot spots.|
|Perform a manual defragmentation of any databases needing reorganization or rebuilding.|
|Create policies to automate your defragmentation.|