You administer a SQL Server 2008 instance. The server contains a very large database that
is used by an application that is constantly available.
Users report that the server performance has degraded.
You need to use the Database Engine Tuning Advisor to improve the performance of the
application.
You also need to ensure that the performance of the production server is unaffected while
analyzing the workload.
What should you do?
A.
Enable the XP_MSVER stored procedure on the local server.
B.
Enable the XP_MSVER stored procedure on the remote server.
C.
Use the dta.exe utility on the production server along with an XML input file.
D.
Configure a test server that has a similar hardware configuration. Use the dta.exe utility
on the test server along with an XML input file.