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&en
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.