Microsoft
70-432 · Question #93
You are the administrator of a 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…
The correct answer is B. Use SQL Profiler to recapture the workload to a trace file. See the full explanation below for the reasoning.
Question
You are the administrator of a 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?
Options
- AUse the data collector to recapture the workload.
- BUse SQL Profiler to recapture the workload to a trace file.
- CEnable the XP_MSVER stored procedure on the local server.
- DEnable the XP_MSVER stored procedure on the remote server.
How the community answered
(45 responses)- A2% (1)
- B82% (37)
- C11% (5)
- D4% (2)
Community Discussion
No community discussion yet for this question.