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 also be able to view the deadlock chain.
What should you use?
A . DBCC OPENTRAN()
B . SQL Profiler
C . sys.dm_exec_sessions
D . Query Store
Answer: A