You can use SQL Defrag Manager to analyze database index fragmentation across your enterprise. Analyzing indexes allows you to find and defragment hot spots to improve performance. SQL Defrag Manager uses policies to automate this process and maintain your databases with minimal time and effort.
Accessing policies
To view information about any policy, click the Automation Policies tab. You can view information about all your policies (per type) or view the status of an individual policy. You can also create new policies, edit existing policies, import, and export policies from this view.
Creating a policy
Before creating an automated defragmentation policy, review the required information so that you can create an efficient and effective policy.