Microsoft
70-450 · Question #5
You administer a SQL Server 2008 instance. Customers report server performance degradation because of a newly implemented process. You use Dynamic Management Views to verify that there are no long…
The correct answer is C. Use SQL Server Profiler and System Monitor. See the full explanation below for the reasoning.
Question
You administer a SQL Server 2008 instance. Customers report server performance degradation because of a newly implemented process. You use Dynamic Management Views to verify that there are no long running queries. You need to correlate the operating system performance data with the actual query execution trace by using minimum administrative effort. What should you do?
Options
- AUse Data Collector.
- BUse the SQLdiag.exe utility.
- CUse SQL Server Profiler and System Monitor.
- DUse SQL Server Profiler and the tracerpt.exe utility.
How the community answered
(48 responses)- A10% (5)
- B4% (2)
- C81% (39)
- D4% (2)
Community Discussion
No community discussion yet for this question.