You administer a remote SQL Server 2008 instance. Users report that the performance of
the application is poor.
You use SQL Profiler to capture a workload of the remote instance to a trace table on the
remote SQL Server instance.
You need to analyze the workload of the remote SQL Server instance on a local SQL Server
instance by using the Database Engine Tuning Advisor.
What should you do?
A.
Use the data collector to recapture the workload.
B.
Use SQL Profiler to recapture the workload to a trace file.
C.
Enable the XP_MSVER stored procedure on the local server.
D.
Enable the XP_MSVER stored procedure on the remote server.