You can use SQL Defrag Manager to analyze database index fragmentation across your enterprise. You can then defragment hot spots to improve performance. SQL Defrag Manager provides policies to automate this process and maintain your databases with minimal time and effort. From the Automation Policies tab, click the Create option to access the Policy Configuration wizard.
If you want to perform manual defragmentation activities, you do not need to define a policy. The policies define how SQL Defrag Manager handles automated analysis activities and the defragmentation activities related to the results of those automated analyses.
If you want to define custom settings for specific database objects, such as creating To Do items for fragmentation issues identified in a very large index instead of attempting to automatically defragment that index, you should define the policy for those specific database objects.
Need more help? Search the IDERA Customer Support Portal
|