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.
How do I access 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 or edit existing policies from these views.
How do I create a policy?
Before creating an automated defragmentation policy, review the required information so that you can create an efficient and effective policy.