Page History
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.
To get started with the Policy wizard:
- Select the indexes you want to evaluate.
- Select the index thresholds and analysis frequency.
- Select index filter options.
- Select policy response
- Schedule when and how often you want the policy to run
- Select which resource checks you want to run before running the policy.
- Select what action you want to occur when certain conditions are met.
- Name the policy.
...