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 usage, Server processes paging and Deadlocks. A&ens
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).