You work as a database administrator at ABC.com.ABC.com is making use of a SQL Server 2008
R2 instance.
ABC.com includes a database that is used by an application that is integral to daily operations.
You are then informed by a ABC.com user that the server is not running as it should be.
You need to make use of the Database Engine Tuning Advisor to enhance the application’s
execution, while preventing other users from being affected by server performance.
You start by setting up a test server, named ABCTEST-SR01 that has the same hardware setting
as the server with the performance issue.
Which of the following actions should you take NEXT? (Choose all that apply.)
A.
You should consider running the dtexec.exe utility on ABCTEST-SR01.
B.
You should consider running the bcp.exe utility on ABCTEST-SR01.
C.
You should consider running the dta.exe utility on ABCTEST-SR01.
D.
You should consider running the sqlmaint.exe utility on ABCTEST-SR01.
Explanation: