Database Tuning Advisor

E56731
SQL Server component database performance tuning tool

Database Tuning Advisor is a SQL Server tool that analyzes workloads and recommends optimal indexes, indexed views, and partitioning strategies to improve database performance.

Jump to: Surface forms Statements Referenced by

Observed surface forms (1)

Surface form Occurrences
Index Tuning Wizard 1

Statements (46)

Predicate Object
instanceOf SQL Server component ⓘ
database performance tuning tool ⓘ
analyzes query cost ⓘ
query plans ⓘ
workload frequency ⓘ
benefit helps identify missing indexes ⓘ
helps remove redundant indexes ⓘ
improves overall throughput ⓘ
reduces manual index design effort ⓘ
commandLineExecutable dta.exe ⓘ
configurationOption index types to consider ⓘ
maximum space for recommendations ⓘ
partitioning options to consider ⓘ
tuning time limit ⓘ
developedBy Microsoft ⓘ
documentationUrl https://learn.microsoft.com/sql/tools/database-tuning-advisor/database-tuning-advisor ⓘ
goal improve database performance ⓘ
optimize query performance ⓘ
hasInterface command-line interface ⓘ
graphical user interface ⓘ
input SQL Server workload ⓘ
Transact-SQL scripts ⓘ
trace files ⓘ
introducedIn SQL Server ⓘ
surface form: SQL Server 2005
output estimated performance improvement reports ⓘ
index recommendations ⓘ
indexed view recommendations ⓘ
partitioning recommendations ⓘ
partOf SQL Server ⓘ
surface form: Microsoft SQL Server
predecessor Database Tuning Advisor self-linksurface differs ⓘ
surface form: Index Tuning Wizard
primaryFunction analyze database workloads ⓘ
recommend physical database design changes ⓘ
recommends indexed views ⓘ
indexes ⓘ
partitioning strategies ⓘ
requires SQL Server ⓘ
surface form: SQL Server database engine
runsOn Windows ⓘ
supportsFeature evaluation of existing indexes ⓘ
limiting recommendations by storage constraints ⓘ
tuning specific databases ⓘ
tuning specific queries ⓘ
tuning specific tables ⓘ
what-if analysis of physical design changes ⓘ
supportsPlatform SQL Server ⓘ
surface form: Microsoft SQL Server
uses query optimizer cost model ⓘ
workload analysis ⓘ

Referenced by (2)

Full triples — surface form annotated when it differs from this entity's canonical label.

Database Tuning Advisor → predecessor → Database Tuning Advisor self-linksurface differs ⓘ
this entity surface form: Index Tuning Wizard
SQL Server → supportsFeature → Database Tuning Advisor ⓘ