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 infrastructure is managed by you.
After a regular test, you find that performance degradation is experienced by an instance for the three reasons:
Excessive CPU, usageServer processes paging and Deadlocks A monitoring solution should be
implemented to provide data, monitor and troubleshoot performance issues.
And detailed deadlock information should be contained in the provided data.
You should utilize the least amount of administrative effort to finish the task.
Which tool will you utilize to finish the task?
A.
To finish the task, you should utilize Resource Governor.
B.
To finish the task, you should utilize Database Engine Tuning Advisor.
C.
To finish the task, you should utilize Extended Events.
D.
To finish the task, you should utilize Performance Monitor (SYSMON).