You have a database that is accessed by 300 concurrent users. You need to log all of the queries that become deadlocked. The solution must meet the following requirements: ✑ Provide a representation of the deadlock in XML format. ✑ Minimize the impact on the server. What should you create?
A. A SQL Server Profiler trace
B. A script that enables trace flags
C. A SQL Server Agent job that retrieves information from the sys.dm_tran_active_transactions dynamic management views
D. A SQL Server Agent job that retrieves information from the sys.dm_tran_session_transactions dynamic management views