You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains a database server named Certkiller -DB01 B01. Certkiller -DB01 hosts a database named CK_Manufacturing that stores data from the Manufacturing department. Several tables in the CK_Manufacturing database have more than one million rows. You have created a clustered index on each table in the CK_Manufacturing database as well as a nonclustered index on each table that is used frequently. You want to optimize performance for the CK_Manufacturing database. You create a trace file for a workload in SQL Server Profiler. You now want to tune the workload file.
What should you do?
A.
Run the Index Tuning Wizard.
B.
Run the dta utility at a command prompt.
C.
Run the sqlmaint utility at a command prompt.
D.
Run the profiler90 utility at a command prompt.
Explanation:
The dta utility is the command line version of the Database Engine Tuning Advisor. It can be used to analyze the workload file and tune the database.
Incorrect Answers:
A: The Index Tuning Wizard has been replaced in SQL Server 2005 by the Database Engine Tuning Advisor. The dta utility is the command line version of the Database Engine Tuning Advisor
C: The sqlmaint utility is used to run database maintenance plans that have been created in previous versions of SQL Server.
D: The profiler90 utility is used to launch the SQL Server Profiler from the command line. It is not used to tune the workload file.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: dta utility Microsoft SQL Server 2005 Books Online (2006), Index: performance [SQL Server], Database Engine Tuning Advisor
Microsoft SQL Server 2005 Books Online (2006), Index: sqlmaint utility Microsoft SQL Server 2005 Books Online (2006), Index: profiler90 utility