You have a database that is accessed by 300 concurrent users. You need to log all of the queries that become deadlocked.
Posted: Mon Oct 17, 2022 4:50 pm
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
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