You have a SQL Server 2012 database named DB1 that is accessed by 650 concurrent
users.
You need to log all of the queries to DB1 that become deadlocked. The solution must
minimize the impact on the server.
What should you create?
A.
A SQL Server Profiler trace
B.
A SQL Server Agent job that retrieves information from the
sys.dm_tran_session_transactions dynamic management views
C.
A SQL Server Agent job that retrieves information from the
sys.dm_tran_active_transactions dynamic management views
D.
A script that enables trace flags
I think it has to be A ?
Who agree ?
I thing the answer D is correct.
The question is to log, and profiler is not writing to log.
The questiion is about all queries, and profiler can skip some data and can’t run all the time.
Trace flags write the query to log:
https://technet.microsoft.com/en-us/library/ms178104%28v=sql.105%29.aspx
D
D