The Policy window lets you select policies to apply to the instance you are registering. Select the policies you want to apply, and then click Finish. The following sample policies are available:
Rebuild Online Daily Top 10
Rebuild Online if available on a daily schedule the top 10 most fragmented indexes over 70%
Rebuild Weekly All
Rebuild indexes where fragmentation is greater than 70% and page count is greater than 1,000
Reorganize Daily All (Nightly Window)
Reorganize indexes where fragmentation is greater than 30% and page count is greater than 1,000
Reorganize Interval Top 10%
Reorganize the top 10% of the indexes on a one-hour interval that are greater than 30% fragmented
Reorganize Interval Top 10
Reorganize the top 10 indexes on a one-hour interval that are greater than 30% fragmented
Reorganize Large Indexes (Nightly Window)
Reorganize the largest indexes (greater than 10,000 pages) with fragmentation greater than 70% only during the nightly maintenance window (12 am to 4 am)
To Do List Reorganize Large Indexes
Run a policy once a week to create a To Do list of large indexes (greater than 10,000 pages) that are candidates for reorganization
To Do List Reorganize Medium Indexes
Run a policy daily to create a To Do list of medium indexes (greater than 1,000 but less than 10,000 pages) that are candidates for reorganization.