You work as a database administrator at ABC.com. ABC.com is using a remote instance of SQL
Server 2008 R2.
Subsequent to receiving complaints that applications are running sluggishly, you decide to make
use of the Database Engine Tuning Advisor to examine a workload of the remote SQL Server
2008 R2 instance on a local SQL Server 2008 R2 instance.
Which of the following actions should you take?
A.
You should consider running the dtexec.exe utility on the remote SQL Server 2008 R2 instance.
B.
You should consider running the dtexec.exe utility on the remote SQL Server 2008 R2 instance.
C.
You should consider capturing the workload to a trace file on the local SQL Server 2008 R2
instance by making use of the SQL Server Profiler.
D.
You should consider capturing the workload to a trace file on the remote SQL Server 2008 R2
instance by making use of the SQL Server Profiler.
Explanation: