What should you create?

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?

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



Leave a Reply 4

Your email address will not be published. Required fields are marked *


Mido

Mido

I think it has to be A ?
Who agree ?