You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo.
You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security,
troubleshooting, deployment and optimization.
A SQL Server 2008 instance should be managed. 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, Data Collector should be utilized.
B.
To finish the task, the SQLdiag.exe utility should be utilized.
C.
To finish the task, SQL Server Profiler and the tracerpt.exe utility should be utilized.
D.
To finish the task, SQL Server Profiler and System Monitor should be utilized.