You are a professional level SQL Sever 2008 Database Administrator. 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 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 Extended Events.
B.
To finish the task, you should utilize Performance Monitor (SYSMON).
C.
To finish the task, you should utilize Resource Governor.
D.
To finish the task, you should utilize Database Engine Tuning Advisor.