How to: Tune a Database
Database Engine Tuning Advisor is a client physical database design tuning tool that you can run either from a graphical user interface (GUI) or from a command prompt executable file, the dta utility. Database Engine Tuning Advisor analyzes workloads in the form of a file or table that contains Transact-SQL statements. For information about creating workload files and tables, see How to: Create Workloads.
In This Section
Contains information about using the Database Engine Tuning Advisor GUI to tune a database.
Contains information about using the dta command prompt utility to tune a database.