Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Select the indexes you want to evaluate.
  2. Select the index thresholds and analysis frequency.
  3. Select index filter options.
  4. Select policy response
  5. Schedule when and how often you want the policy to run
  6. Select which resource checks you want to run before running the policy.
  7. Select what action you want to occur when certain conditions are met.
  8. Name the policy.

Do I have to define automation policies?

...

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 IDERA Customer Support Portal