Available Tuning Options

Database Engine Tuning Advisor offers users the capability to tune workloads with the dta command-prompt utility or the application's graphical user interface (GUI). Either through the GUI or the command prompt, users can specify the types of indexes and partitioning for Database Engine Tuning Advisor to consider in a recommendation, whether to keep or consider dropping existing indexes and partitioning, and the maximum disk space that recommended configurations can consume. For a complete reference of all dta utility options, see dta Utility. For information about the options available in the GUI, press F1 when the Tuning Options tab is selected.

In This Section

• Specifying Physical Design Structures
  Contains information about the tuning options for specifying which physical design structures to consider or keep when using either Database Engine Tuning Advisor GUI or the dta utility. Physical design structures are objects such as indexes, indexed views, or partitioning.

• Limiting Tuning Duration and Events
  Contains information about setting a limit for the time Database Engine Tuning Advisor tunes a workload and for limiting the number of events tuned.

• Limiting Disk Space for Recommendations
  Contains information about setting a limit for the amount of disk space a tuning recommendation can consume.

• Scenarios for Choosing Tuning Options
  Contains usage scenarios for choosing tuning options.

• Unsupported Tuning Options
  Contains information about which tuning options are not supported.