Page tree

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, delete, enable, or disable existing policies, as well as to import and export policies.

Creating a policy

Before creating an automated defragmentation policy, review the required information so that you can create an efficient and effective policy.