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.
In This Section
| Topic | Description |
|---|---|
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. |
|
Contains information about setting a limit for the time Database Engine Tuning Advisor tunes a workload and for limiting the number of events tuned. |
|
Contains information about setting a limit for the amount of disk space a tuning recommendation can consume. |
|
Contains usage scenarios for choosing 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. |