PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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