The Targets tab allows you to select the indexes you want this policy to evaluate. Your selection in the Index Types drop-down list determines whether SQL defrag manager displays all indexes, or only clustered or non-clustered indexes.
TIP |
Changing the Index Type clears the selected targets. |
What information is on the Targets tab?
On the Targets tab, you can select the indexes that you want to evaluate using this policy.
What do I do if my indexes are not listed?
If your indexes are not displayed in the available list, you can register your SQL Server with SQL defrag manager by clicking Cancel, and then clicking Master Control > Register.
How do I index individual partitions?
SQL defrag manager evaluates all partitions in an index based on the settings in the Thresholds tab and reacts according to the settings in the Response tab. The Thresholds tab allows you to set your fragmentation and scan density rules, and your analysis frequency. The Response tab lets you choose how you want the policy to respond in a certain situation.