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.