You are a professional level SQL Sever 2008 Database Administrator. It is reported by the
customers that the server performance degraded due to a newly implemented process.
Dynamic Management Views is utilized to confirm that no long running queries exist. The
operating system performance data should be correlated with the actual query execution
trace, and the least administrative effort should be utilized. Which action will you perform to
finish the task?
A.
To finish the task, SQL Server Profiler and System Monitor should be utilized.
B.
To finish the task, SQL Server Profiler and the tracerpt.exe utility should be utilized.
C.
To finish the task, Data Collector should be utilized.
D.
To finish the task, the SQLdiag.exe utility should be utilized.