The Response tab allows you to select how the policy responds when the specified conditions are met.
What are the advantages of each optimize response?
Reorganize does not hold long-term table locks and has less impact to availability. However, it results in less reduction of fragmentation levels. Rebuild has a higher impact on your system availability, but provides the best results in reduction of fragmentation. If availability during the rebuild is important, select ONLINE (SQL 2005/2008 only), but note that this option requires additional operation time and resource consumption. Use SORT_IN_TEMPDB to direct SQL Server to use tempdb for the intermediate sort results used to build the index. For more information, see Microsoft Books Online.
TIP |
If you select Rebuild, the ONLINE (SQL 2005/2008 only) option applies to the Enterprise versions of SQL Server 2005, 2008, and 2008 R2. |
What if I don't want SQL defrag manager to automatically defragment after running this policy?
You can select whether you want SQL defrag manager to automatically defragment qualifying indexes or to add them to the To Do list. These responses define what SQL defrag manager does when it identifies a fragmented index during an automated, scheduled analysis. For example, if you select Yes, Automatically Defrag, when SQL defrag manager performs a scheduled analysis activity, SQL defrag manager attempt to defragment each index it finds that is not compliant with policy using the selected reorganize or rebuild method. If you select No, Add To Do item, when SQL defrag manager performs a scheduled analysis activity, SQL defrag manager creates a To Do item on the To Do view of the SQL defrag manager Console for each index it finds that is not compliant with policy.
What are my options for updating the statistics?
The SQL defrag manager Response tab provides three options for updating your statistics. Before Analysis Renewal updates the statistics for each object covered by this policy each time an analysis is performed. If a reorganization or rebuild is necessary, use Before Optimization to update the statistics before the reorganization or rebuild occurs so the query optimizer has the most current information for building the execution plan for the operation. Never prevents any statistics updates regardless of what other activities occurred.
Check the Use NORECOMPUTE option check box, and SQL Server does not maintain the statistics after you perform a manual update. Leave this check box unchecked and SQL Server maintains statistics after a manual update. This check box is unchecked by default.