What is Database Engine Tuning Advisor?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is Database Engine Tuning Advisor?
Rating:
Database Engine Tuning Advisor is a tool that tunes a database for better query performance by analyzing a workload that is a set of T-SQL statements. It suggests clustered indexes, nonclustered indexes, indexed views, and partitioning. Database Engine Tuning Advisor in SQL Server 2005 replaces the Index Tuning Wizard of SQL Server 2000. This tool provides two user interfaces: a graphical user interface (GUI) and the dta command prompt utility.
Rating:
Was this information helpful?
Other articles
- What is a nonclustered index?
- What is a nondeterministic function?
- What is SQL Profiler?
- What is the SNAPSHOT isolation level?
- What is the db_dtsoperator fixed-database role?