This documentation is archived and is not being maintained.

Available Tuning Options

New: 5 December 2005

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.

Topic Description

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 on SQL Server 2005 Standard Edition, and which are not supported on all editions of SQL Server 2000.