Database Reference
In-Depth Information
Figure 10-7.
Tuning Options tab adjusted
Notice that the description at the bottom of the screen changes as you change the definitions in the selections
made above. After starting the analysis, the progress screen should appear. Although the settings were for one hour of
evaluations, it took only about a minute for the DTA to evaluate this query. The initial recommendations were not a
good set of choices. As you can see in Figure
10-8
, the Database Engine Tuning Advisor has recommended dropping a
huge swath of indexes in the database. This is not the type of recommendation you want when running the tool.
