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.