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
Topic | Description |
---|---|
How to: Tune a Database by Using Database Engine Tuning Advisor |
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. |
See Also
Other Resources
Database Engine Tuning Advisor Reference
Tuning the Physical Database Design