You are the administrator of your company network. And you’re in charge of a SQL Server 2008 infrastructure. You check and find that the performance of the instance is degrading. And this may because of deadlocks, excessive CPU usage or server processes paging. You have to work out a solution to monitor and identify performanceproblems. Your solution should provide information, including detailed deadlock information. You have to do this with as little administrative effort as possible. So which tool should you use?
A.
You should use Extended Events
B.
You should use Resource Governor
C.
You should use Performance Monitor (SYSMON)
D.
You should use Database Engine Tuning Advisor