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?

A.
Use Data Collector.

B.
Use the SQLdiag.exe utility.

C.
Use SQL Server Profiler and System Monitor.

D.
Use SQL Server Profiler and the tracerpt.exe utility.

Explanation: