Microsoft
70-432 · Question #5
You are the administrator of a SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance, you capture a workload of the remote instance to a…
The correct answer is D. You should recapture the workload to a trace file by using SQL Profiler. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance, you capture a workload of the remote instance to a trace table by using SQL Profiler. You use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance. Which action should you perform to achieve this goal?
Options
- AYou should recapture the workload by using the data collector.
- BYou should enable the XP_MSVER stored procedure on the local server.
- CYou should enable the XP_MSVER stored procedure on the remote server
- DYou should recapture the workload to a trace file by using SQL Profiler.
How the community answered
(21 responses)- B10% (2)
- C5% (1)
- D86% (18)
Community Discussion
No community discussion yet for this question.