You administer a SQL Server 2008 infrastructure.
You discover that an instance experiences performance degradation for the following reasons:
Excessive CPU usage
Server processes paging
Deadlocks
You need to design a monitoring solution that can provide data, including detailed deadlock information, to
monitor and troubleshoot performance issues. You want to achieve this goal by using the minimum amount
of administrative effort.
What tool should you use?
A.
Extended Events
B.
Resource Governor
C.
Database Engine Tuning Advisor
D.
Performance Monitor (SYSMON)