You run the sp_who system stored procedure. A process is blocked by a long-running operation.
You need to identify details of the processes involved in the deadlock including the resources that are being accessed. You must able to view the deadlock chain.
What should you use?
A . DBCC OPENTRAN()
B . Extended events
C . Query performance insights
D . Data collector
Answer: B
Explanation:
SQL Server Extended Events has a highly scalable and highly configurable architecture that allows users to collect as much or as little information as is necessary to troubleshoot or identify a performance problem.